# Faulted database connection? **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [August 23, 2024, 5:03pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093 "2024-08-23T17:03:21Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jessica\_Peterson](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@Jessica\_Peterson](https://forum.inductiveautomation.com/u/Jessica_Peterson)\ **Post date:** [August 23, 2024, 5:03pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/1 "2024-08-23T17:03:21Z")
Hi all, I am attempting to setup a database connection in Ignition for the first time. I am using SQL Express 2022. I have tried lots of different settings in the gateway, but I keep getting "faulted" as my status. I installed SQL Express 2022 and created a database called "database1." Do I need to do anything else in SSMS for the database to be functional. I have installed the MySQL Connector/J driver. I setup the database in the gateway follows: Config\>Databases\>Database Connections\>Create new Database connection\>MySQL Connect URL= `jdbc:mysql://localhost:3306/SQLEXPRESS1` Should this be equal to "Server Name"? I have tried both. "SQLEXPRESS1" and "DESKTOP-S2UTNSE\SQLEXPRESS1," but both result in faults. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/c/6c8803f79823873666facfef778ce35342111a46.png) Username/Password have been verified to work in SSMS per SQL Server Authentication. Extra Connection Properties: `databasename=database1` Database1 is the name of my database in MySQL ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/3603a47c84e83da1bc38c1bd50436723ca50ee06.png) ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [August 23, 2024, 5:07pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/2 "2024-08-23T17:07:49Z")
> [@Jessica\_Peterson](#): > > Config\>Databases\>Database Connections\>Create new Database connection\>MySQL That is the driver for MY SQL. Not MS SQL Choose MSSql as the driver. ---
**Author:** ![Jessica\_Peterson](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@Jessica\_Peterson](https://forum.inductiveautomation.com/u/Jessica_Peterson)\ **Post date:** [August 23, 2024, 5:15pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/3 "2024-08-23T17:15:53Z")
I had tried both, still faulted with MSSQL, unfortunately. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/1805f3b70bd34846598569a4b8e8e02f9e9eadfa.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/a/fa9dab2d36b749d9f096f84124d6e3539b41a462.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 23, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/4 "2024-08-23T17:32:23Z")
You are using SQL **Express**. That doesn't allow user/password authentication by default. (You will regret using it when you hit its size limits, too.) ---
**Author:** ![djs](https://avatars.discourse-cdn.com/v4/letter/d/e47774/32.png) [@djs](https://forum.inductiveautomation.com/u/djs)\ **Post date:** [August 23, 2024, 8:49pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/6 "2024-08-23T20:49:16Z")
`jdbc:sqlserver://localhost\SQLEXPRESS1` should work fine if your database is running on the same machine, and if you left the port as the default 1433. I've had no problems with user/password authentication with SQL Express. I would however agree with Phil and say that you should only use Express for testing on a dev environment (because of its size limits). In production, use SQL Server if you must use MS SQL. The status page for database connections provides a more detailed message when the connection is faulted. What is the error message when you click on "Error" or the _Details_ button on the **Status page**? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ff312620ec30c432486ea6692675378b35a2d846.png) ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [August 24, 2024, 3:14pm UTC](https://forum.inductiveautomation.com/t/faulted-database-connection/95093/7 "2024-08-24T15:14:27Z")
The docs have a lot of useful information, don't forget they exist. > **[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)** > > This guide helps you with any difficulties you may have in getting the correct settings and parameters when connecting Ignition to Microsoft SQL Serverv