# Issue with Ignition connecting to MSSQL server

**URL:** <https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 24, 2025, 3:10pm UTC](https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899 "2025-07-24T15:10:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![William\_Gibson](https://avatars.discourse-cdn.com/v4/letter/w/a88e4f/32.png) [@William\_Gibson](https://forum.inductiveautomation.com/u/William_Gibson)\
**Post date:** [July 24, 2025, 3:10pm UTC](https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899/1 "2025-07-24T15:10:14Z")

</div>

I am trying to connect to an MSSQL server using Windows Authentication. Here is a summary of the issues I have ran into.

Initial Error:

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

After talking with inductive support, I followed the guide here to implement integrated auithentication:

> **[Connecting to Microsoft SQL Server Express | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/connecting-to-microsoft-sql-server-express#set-up-the-service-to-use-windows-authentication)**
>
> This guide helps you with any difficulties you may have in getting the correct settings and parameters when connecting Ignition to Microsoft SQL Serverv

That resulted in these new issues.

 ![WindowsUser](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/068b2c1a3ebdafbce1a377cd44b66b6b5aa26aa6.png)  
 ![ServiceStartError](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/d/3d704f107903a9906fab833054c9c907032ca760.png)

Troubleshooting with support gave this summary

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

Lastly, I am able to connect to the database directly from the operating system, but not from Ignition, so I don't think it is a windows Issue.

If anyone has any ideas on how to resolve this or a path forward, it is greatly appreciated.

---

<div class="post-metadata">

**Author:** ![tgarrison](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tgarrison/32/80965_2.png) [@tgarrison](https://forum.inductiveautomation.com/u/tgarrison)\
**Post date:** [July 24, 2025, 4:05pm UTC](https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899/2 "2025-07-24T16:05:53Z")

</div>

#4 in that report is key. Work with your IT dept to figure out why it isn't able to run the Ignition Service using that account.

---

<div class="post-metadata">

**Author:** ![Daniel\_Calderon](https://avatars.discourse-cdn.com/v4/letter/d/51bf81/32.png) [@Daniel\_Calderon](https://forum.inductiveautomation.com/u/Daniel_Calderon)\
**Post date:** [October 8, 2025, 3:25pm UTC](https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899/3 "2025-10-08T15:25:45Z")

</div>

Hi @William_Gibson Did you ever fix this? I have exact same situation right now.

---

<div class="post-metadata">

**Author:** ![Daniel\_Calderon](https://avatars.discourse-cdn.com/v4/letter/d/51bf81/32.png) [@Daniel\_Calderon](https://forum.inductiveautomation.com/u/Daniel_Calderon)\
**Post date:** [October 8, 2025, 3:57pm UTC](https://forum.inductiveautomation.com/t/issue-with-ignition-connecting-to-mssql-server/108899/4 "2025-10-08T15:57:40Z")

</div>

Fixed it. IT made the service account able to run services on the server PC.