# SQL connectivity issue

**URL:** <https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [September 12, 2022, 5:05am UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958 "2022-09-12T05:05:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Srushti\_Nagulwar](https://avatars.discourse-cdn.com/v4/letter/s/77aa72/32.png) [@Srushti\_Nagulwar](https://forum.inductiveautomation.com/u/Srushti_Nagulwar)\
**Post date:** [September 12, 2022, 5:05am UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/1 "2022-09-12T05:05:36Z")

</div>

Hello Team,

```
              I am facing SQL connectivity issue while trying to connect sql server with igntion. Here is the attached error I am getting while trying to connect. I am using sql auth for connection with sa login.

```

 ![MicrosoftTeams-image (3)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e52d580d1e22fc387f68c6c5d3f2c4c2e9b0dec.png)

Thanks

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 12, 2022, 11:17am UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/2 "2022-09-12T11:17:37Z")

</div>

Welcome to the forum, Srushti.  
You have somehow managed to format your post as code and the paragraph doesn’t wrap. You can use the 🖉 edit link to fix it. Try removing any leading spaces from the paragraph “I am facing …” and it will format correctly and you’ll get proper word-wrap.

Then post the error log **as code** using the \</\> code formatting button so we can read the cropped off text.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [September 12, 2022, 1:08pm UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/3 "2022-09-12T13:08:15Z")

</div>

```auto
Login failed for user 'sa'

```

Ensure you have the correct password in the database connection properties, and that SQL server has allowed Ignition the privileges to connect

> [@Cannot create PoolableConnectionFactory - MSSQL 2019 Standard](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-mssql-2019-standard/53008/7):
>

---

<div class="post-metadata">

**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:** [September 12, 2022, 2:09pm UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/4 "2022-09-12T14:09:23Z")

</div>

> [@Matrix\_Engineering](#):
>
> Ensure you have the correct password in the database connection properties

Agreed with this--if you're getting to the point of receiving "Login failed", it means you're able to establish a socket connection to SQL Server, so connectivity is probably okay. Time to re[set] that password in the DB connection properties per @Matrix_Engineering guidance.

---

<div class="post-metadata">

**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:** [September 12, 2022, 3:48pm UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/5 "2022-09-12T15:48:38Z")

</div>

Also, I would highly recommend _not_ using the `sa` user login for Ignition. Create a new, dedicated user for Ignition use.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [September 12, 2022, 5:11pm UTC](https://forum.inductiveautomation.com/t/sql-connectivity-issue/63958/6 "2022-09-12T17:11:35Z")

</div>

@paul-griffith  
That was exactly what was going through the back of my head as I read this. Using the sa username/password for outside database access is probably not the best practice.

@Srushti_Nagulwar  
Creating separate ignition login credentials for the database and using them instead would be the best approach to fixing this problem.