# SQLServer PoolableConnectionFactory Login failed

**URL:** <https://forum.inductiveautomation.com/t/sqlserver-poolableconnectionfactory-login-failed/96989>\
**Category:** Ignition\
**Created:** [October 8, 2024, 7:10pm UTC](https://forum.inductiveautomation.com/t/sqlserver-poolableconnectionfactory-login-failed/96989 "2024-10-08T19:10:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_Pierce](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@Jason\_Pierce](https://forum.inductiveautomation.com/u/Jason_Pierce)\
**Post date:** [October 8, 2024, 7:10pm UTC](https://forum.inductiveautomation.com/t/sqlserver-poolableconnectionfactory-login-failed/96989/1 "2024-10-08T19:10:44Z")

</div>

Hello, I am new to Ignition and SQL and encountered the same error as above.

In Ignition\>Databases\>Connections: Username and password are correct; Connect URL is set to the correct server and valid, Extra Connections Properties is valid with the correct database name.

 ![error message 1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7eef89ecdb2deae09b73f4e6918c80a1d10ba32b.jpeg)

---

<div class="post-metadata">

**Author:** ![Jason\_Pierce](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@Jason\_Pierce](https://forum.inductiveautomation.com/u/Jason_Pierce)\
**Post date:** [October 8, 2024, 7:20pm UTC](https://forum.inductiveautomation.com/t/sqlserver-poolableconnectionfactory-login-failed/96989/2 "2024-10-08T19:20:31Z")

</div>

I'll add, as mentioned in another [post](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-mssql-2019-standard/53008), under Extra Connection Properties I followed my databaseName with the below and received this error:

databaseName=insertedmydatabase; integratedSecurity=true; encrypt=false;

 ![error message 2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/0/60179a818c180ccd855092269a7e937952be9d0d.jpeg)

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [October 8, 2024, 7:22pm UTC](https://forum.inductiveautomation.com/t/sqlserver-poolableconnectionfactory-login-failed/96989/3 "2024-10-08T19:22:31Z")

</div>

The original post I split this from (not the same one you just linked) is not actually the same error message, you shouldn't copy its advice.

Your error message says the login just straight up failed. You have the wrong username/password or that user doesn't have permissions to access this schema/db, or perhaps isn't allowed via TCP vs named pipes, etc...