# Unable to connect with MSSQL db **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [December 7, 2021, 11:13am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827 "2021-12-07T11:13:05Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Sourabh\_Ambildhuke](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Post date:** [December 7, 2021, 11:13am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/1 "2021-12-07T11:13:06Z")
Hi eveyone, trying to connect ignition with Microsoft SQL but not getting succeed. I am trying to create connection. Name - Batch Connect URL - systemname \MSSQLEXPRESS username - sa Db name - Batch\_process But i am getting error as “Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:7de7f731-f2fc-47c0-aea3-24709038261d)” Prerequesites as SQL browser running. TCP is enabled and dynamic port is set to 0 sa login is enabled from sql jdbc file is copyed into lib folder in C drive. Still the issue persist. Any help would be appreciated. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [December 7, 2021, 11:21am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/2 "2021-12-07T11:21:49Z")
> [@Sourabh\_Ambildhuke](#): > > This driver is not configured for integrated authentication. This is because you are trying to use Windows authentication. You can try - Adding the proper DLL as per this link: [[Resolved] SQL Error : This driver is not configured for integrated authentication - DevDummy](https://www.devdummy.com/2019/10/resolved-sql-error-this-driver-is-not.html) - Add a database user to SQLExpress and use the database authentication instead. (I recommend this one) ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [December 7, 2021, 2:44pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/3 "2021-12-07T14:44:57Z")
Just an aside but you should create a specific user for Igniton to log in to your database and set appropriate privleges, don’t use sa as that has complete control over your database which could prove very bad if a nefarious actor was able to leverage your app. ---
**Author:** ![Sourabh\_Ambildhuke](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Post date:** [December 9, 2021, 4:31am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/4 "2021-12-09T04:31:58Z")
Hi, After every possible way of connecting with SQL, I am unable to do the connection. I have did SQL auth file in ignition lib folder, then started SQL server browser and TCP/IP port is dynamic as per the tutorial in inductive automation. The recent issue is shown below. Cannot create PoolableConnectionFactory (The connection to the host YPH1013467LT, named instance MSSQLSERVER failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.) ---
**Author:** ![brownja667](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@brownja667](https://forum.inductiveautomation.com/u/brownja667)\ **Post date:** [January 21, 2022, 3:54pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/5 "2022-01-21T15:54:48Z")
@Sourabh_Ambildhuke Have you resolved this issue? I am seeing the same behavior. Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:9f87ec03-edaa-4f50-a56d-7053ca6050ab) This issue has appeared since our upgrade to 8.1.13 ---
**Author:** ![brownja667](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@brownja667](https://forum.inductiveautomation.com/u/brownja667)\ **Post date:** [January 21, 2022, 8:26pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/6 "2022-01-21T20:26:39Z")
I looked at another server 8.1.13 server. It does not appear to be related. Still unsure what the issue is. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [January 21, 2022, 9:46pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/7 "2022-01-21T21:46:21Z")
Did you take care of the DLL? You’ll note that the OP’s error message changed after that. ---
**Author:** ![cesrom](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Post date:** [January 21, 2022, 11:49pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/8 "2022-01-21T23:49:16Z")
This might be helpful. > **[Microsoft SQL Server (MSSQL) Connection Guide for Ignition](https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition)** > > Microsoft SQL Server is a popular robust relational database produced by Microsoft. Ignition can connect to Microsoft SQL Server, however many users find difficulty in getting all of the settings a... ---
**Author:** ![Sourabh\_Ambildhuke](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Post date:** [January 24, 2022, 5:05am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mssql-db/53827/9 "2022-01-24T05:05:49Z")
yes @brownja667 resolved by me, First I have to enable the TCP/IP enable from configuration manager, then give port ID for static as 1433 and choose 0 in dynamic port. Then try to restart the db connection from configuration manager and see if that works or not. Thanks Sourabh A