# Issue for creating a Microsoft Sever **URL:** \ **Category:** Ignition\ **Created:** [April 19, 2024, 2:51pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119 "2024-04-19T14:51:32Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Trung\_Tin\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/t/91b2a8/32.png) [@Trung\_Tin\_Nguyen](https://forum.inductiveautomation.com/u/Trung_Tin_Nguyen)\ **Post date:** [April 19, 2024, 2:51pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/1 "2024-04-19T14:51:32Z")
Had this pop up when I was trying to create a sever according to the Inductive University, anyone have any ideas? Cannot create PoolableConnectionFactory (Login failed for user 'admin'. ClientConnectionId:c64ce8ea-fca2-4a24-b69e-05bf6875f138) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 19, 2024, 3:02pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/2 "2024-04-19T15:02:14Z")
I mean... Is the password correct? Login failed is pretty unambiguous. ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [April 19, 2024, 3:15pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/3 "2024-04-19T15:15:00Z")
Keep in mind that with SQL Server, you have to create a "login" and then associate that login to a database via a "user". ---
**Author:** ![Trung\_Tin\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/t/91b2a8/32.png) [@Trung\_Tin\_Nguyen](https://forum.inductiveautomation.com/u/Trung_Tin_Nguyen)\ **Post date:** [April 21, 2024, 2:23am UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/4 "2024-04-21T02:23:50Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/d/fd8c25b331b92a3f73ae55035f4ba861ff775977.png) Yes, I even copy paste to ensure it was ---
**Author:** ![Trung\_Tin\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/t/91b2a8/32.png) [@Trung\_Tin\_Nguyen](https://forum.inductiveautomation.com/u/Trung_Tin_Nguyen)\ **Post date:** [April 21, 2024, 2:26am UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/5 "2024-04-21T02:26:31Z")
I was able to login on the SQL Server Management Studio a couple of times, but the Igntion never had a Valid status. ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [April 22, 2024, 1:42pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/6 "2024-04-22T13:42:32Z")
Another thing to check is in _SQL Server Configuration Manager_, make sure that TCP/IP protocol is enabled. I think that some installations of SQL Express may not default to enabling TCP/IP. ---
**Author:** ![Trung\_Tin\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/t/91b2a8/32.png) [@Trung\_Tin\_Nguyen](https://forum.inductiveautomation.com/u/Trung_Tin_Nguyen)\ **Post date:** [April 22, 2024, 6:55pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/7 "2024-04-22T18:55:18Z")
thank you for letting me know, yes, I have it set to enable already. ---
**Author:** ![msteele](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/msteele/32/77889_2.png) [@msteele](https://forum.inductiveautomation.com/u/msteele)\ **Post date:** [June 18, 2024, 6:24pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/8 "2024-06-18T18:24:06Z")
Not sure if OP ever got this working, but I'll share another simple reason that I've missed on multiple installs which results in this same error. By default, server authentication only supports Windows Authentication, which does not allow credentials created within SQL Server/SSMS. In **SQL Server Management Studio** : 1. Open up **Server Properties** (right click on server, top level, in your object explorer and select properties). 2. Select the **Security** page within the resulting pop-up. 3. Under Server Authentication, make sure **SQL Server and Windows Authentication mode** is selected. 4. OK You'll need to restart the DB in order for this change to take effect. 1. Open **SQL Server Configuration Manager** software (must be on the host machine) 2. Go to **SQL Server Services** page in the left explorer. 3. Right click **SQL Server (YOURSERVER)** and choose restart. Assuming you have a valid credential identical between Ignition and MS SQL Server and your other settings are correct, you'll likely have a valid database connection in Ignition. Hope this helps OP or anyone else in the future who also cannot yet use @pturmel's advice to avoid all this and just use PostgreSQL instead.... ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/8/f86585ec78efcde3865ea2ff13cdc5bfadd360a3.png) ---
**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:** [June 18, 2024, 6:58pm UTC](https://forum.inductiveautomation.com/t/issue-for-creating-a-microsoft-sever/89119/9 "2024-06-18T18:58:57Z")
Some more info - useful if you need to connect via a Windows Login instead of a SQL Login > **[Connecting to Microsoft SQL Server Express | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/connecting-to-microsoft-sql-server-express#microsoft-sql-server-connection-guide)** > > This guide helps you with any difficulties you may have in getting the correct settings and parameters when connecting Ignition to Microsoft SQL Serverv