# DB Connection Faulted **URL:** \ **Category:** Ignition\ **Tags:** ignition81, database\ **Created:** [December 8, 2025, 2:47am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672 "2025-12-08T02:47:50Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![mehdi.sajjadi](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@mehdi.sajjadi](https://forum.inductiveautomation.com/u/mehdi.sajjadi)\ **Post date:** [December 8, 2025, 2:47am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/1 "2025-12-08T02:47:50Z")
I’m new to Ignition and I’m trying to create value trend logs using the Historian. From what I’ve learned in Ignition University, I need to set up a database connection, but mine is currently showing as **FAULTED**. When creating the database connection, it asks for a **username and password**. My first question is: **Are these credentials supposed to be created earlier in SQL?** I’ve attached a screenshot of my localhost database settings, but I’m not sure if they are correct. Could you please guide me on the correct steps to create the database and set up the connection? ![SQL Setup](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/1/e1386c7c3f84e47263f7bd1aa52c590104537ade.jpeg) Thanks ---
**Author:** ![Cose\_Peter1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cose_peter1/32/79174_2.png) [@Cose\_Peter1](https://forum.inductiveautomation.com/u/Cose_Peter1)\ **Post date:** [December 8, 2025, 4:23am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/2 "2025-12-08T04:23:14Z")
> [@mehdi.sajjadi](#): > > Are these credentials supposed to be created earlier in SQL? Yes. If you are using MSSQL. You can go through these two videos and try to set up the connection. If you still face issues after doing so, you can post the issue with the error message here. > **[Connecting to Microsoft SQL Server Express Video at Inductive University](https://inductiveuniversity.com/videos/connecting-to-microsoft-sql-server-express/8.3)** > > Learn about what configuration settings and connection methods to use when connecting to a Microsoft SQL (MSSQL) Server Express database. > **[Installing Microsoft SQL Server Express Video at Inductive University](https://inductiveuniversity.com/videos/installing-microsoft-sql-server-express/8.3)** > > See a walk-through of installing Microsoft SQL (MSSQL) Server Express and Management Studio. ---
**Author:** ![mehdi.sajjadi](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@mehdi.sajjadi](https://forum.inductiveautomation.com/u/mehdi.sajjadi)\ **Post date:** [December 8, 2025, 7:41am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/3 "2025-12-08T07:41:51Z")
Thanks Peter I have already watched the videos and followed them up, I have attached the steps that I have passed to create DB. Step 1: ![1](https://us1.discourse-cdn.com/inductiveautomation/optimized/3X/f/5/f506413fc65526bd98fdafcb94612a842897c864_2_690x50.jpeg) Step 2: ![2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/96e04ba4f01349ac53d5d7e5d119f2baebe191ae.jpeg) Step 3: Error message ![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/9683141d2c11299dda58a4ed039ce098b5e3d7ee.jpeg) Any missing step. unfortunately I am not very familiar with SQL and haven no idea if the settings are correct. Thanks and Regards ---
**Author:** ![Cose\_Peter1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cose_peter1/32/79174_2.png) [@Cose\_Peter1](https://forum.inductiveautomation.com/u/Cose_Peter1)\ **Post date:** [December 8, 2025, 8:36am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/4 "2025-12-08T08:36:49Z")
> [@mehdi.sajjadi](#): > > Step 3: Error message This is not the error message. The error message is in the database connections section is **status** tab in the gateway. ---
**Author:** ![mehdi.sajjadi](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@mehdi.sajjadi](https://forum.inductiveautomation.com/u/mehdi.sajjadi)\ **Post date:** [December 8, 2025, 9:25am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/5 "2025-12-08T09:25:56Z")
Sorry, wrong attachment. ![4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b288565ea0692dd6bf0950a321c09a295082a7c.jpeg) A quick note, that I have used the username : **sa** and password created at following page while adding SQL connection. ![5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3a5db612123c9fcb4afaedcaab1d821ef96a7a56.jpeg) Thanks ---
**Author:** ![Cose\_Peter1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cose_peter1/32/79174_2.png) [@Cose\_Peter1](https://forum.inductiveautomation.com/u/Cose_Peter1)\ **Post date:** [December 8, 2025, 10:00am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/6 "2025-12-08T10:00:00Z")
Verify if you have set the right server name in **connect URL** section. Also check if you have set `databaseName=test` or to whatever DB name that you have created in **Extra Connection Properties** ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [December 8, 2025, 12:24pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/7 "2025-12-08T12:24:30Z")
This issue is normally because TCP/IP is not enabled on the MSSQL server. See here: [Troubleshooting: Enabling TCP/IP in the SQL Server | DUG Insight User Manual | DUG Insight User Manual](https://help.dugeo.com/m/Insight/l/438913-troubleshooting-enabling-tcp-ip-in-the-sql-server) ---
**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:** [December 8, 2025, 12:45pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/8 "2025-12-08T12:45:53Z")
Two notes; 1. you are running the DB on localhost. This isn’t best practice, if this is for an install that will grow in requirements, run the DB on a separate VM or different server. 2. You are using the SA account. Don’t do that. Create an Ignition user for the DB, and use that. ---
**Author:** ![mehdi.sajjadi](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@mehdi.sajjadi](https://forum.inductiveautomation.com/u/mehdi.sajjadi)\ **Post date:** [December 9, 2025, 12:45am UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/9 "2025-12-09T00:45:48Z")
Thanks @Matrix_Engineering @Cose_Peter1 @jonathan.taylor for your advices. I wasn’t successful on Microsoft SQL ,but could create DB using MySQL. I am very novice at using SQL, so I needed to upgrade my knowledge about it. By the way, I described steps, just in case if someone like me have issue of DB Creation. 1. Installed MySQL , I learned from this YouTube video : [MySQL installation](https://www.youtube.com/watch?v=k65ZdsCpI2E) 2. I have done following settings at ignition Gateway 3. Done! ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/0/b0b5fcba5ae9e6ad7e15e040ae9f7dddefd26706.png) Appreciate you kind support. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [December 9, 2025, 12:56pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/10 "2025-12-09T12:56:56Z")
I know you moved to mysql, but where did you get that instance name from (MSSQLSERVER)? My guess is that you created the instance as the default instance which means this should be blank on the ignition connection. Ie just jdbc…./localhost/ ---
**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:** [December 9, 2025, 1:30pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/11 "2025-12-09T13:30:03Z")
> [@nminchin](#): > > where did you get that instance name from (MSSQLSERVER)? From the docs: [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#connect-to-microsoft-sql-server) MySQL is better anyway, IMO. MSSQL requires a license. ---
**Author:** ![952485837](https://avatars.discourse-cdn.com/v4/letter/9/76d3ee/32.png) [@952485837](https://forum.inductiveautomation.com/u/952485837)\ **Post date:** [December 11, 2025, 2:45pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/12 "2025-12-11T14:45:10Z")
Is your MSSQL server located on the same server ? if not , probably , you need to create an inbound rule to let your Ignition server see the MS SQL server through TCP/IP. ---
**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:** [December 11, 2025, 3:52pm UTC](https://forum.inductiveautomation.com/t/db-connection-faulted/112672/13 "2025-12-11T15:52:25Z")
> [@952485837](#): > > Is your MSSQL server located on the same server ? Based on their connection param of “localhost”, I’d say yes.