# MS SQL Database Connection Issue **URL:** \ **Category:** Ignition\ **Created:** [January 22, 2020, 12:53pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511 "2020-01-22T12:53:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![m.boog](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Post date:** [January 22, 2020, 12:53pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/1 "2020-01-22T12:53:50Z")
I have been developing in Perspective with a MS SQL Server Express database (on the same laptop as the gateway) without issue. I recently updated to the Ignition platform 8.0.7 and I am also on a job site, so I’m on a new network. When I pulled up my projects, the database connections were not connecting, with no change to the projects or the drivers. To make sure I’m not missing something before re-installing the drivers: 1. My understanding is that traffic between the database and the gateway should not be dependent on the network setup, since they are all local. Are there any port considerations I need to be aware of in this setup? 2. I also restored the gateway backup to prior to the gateway upgrade. Any chance something was changed in the upgrade that wasn’t reverted back in the restore? Gateway Log Error ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e72333e65f572f27c13bb5f0fd82a1b9f8d10e67.png) DB Connection Error ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9fee8454e16c403173fc4398408cd6d2527dcb81.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:** [January 22, 2020, 1:07pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/2 "2020-01-22T13:07:24Z")
Does the site use a different version of SQL Server? Your JDBC drivers from your dev environment would be part of the gateway backup, and would replace the production system’s JDBC drivers. ---
**Author:** ![m.boog](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Post date:** [January 22, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/3 "2020-01-22T14:05:09Z")
That’s the thing - the only drivers involved are the ones installed on my local laptop. I wouldn’t expect that my local database setup should be affected at all by the move, unless the MSSQL \<-\> Gateway communications actually went over the network, in which case the router could be blocking traffic on port 1434? Or put another way, can I assume that no network connection is required to run an Ignition gateway that is tied to a SQL database on the same laptop? ---
**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:** [January 22, 2020, 3:01pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/4 "2020-01-22T15:01:21Z")
Is the production database also SQL Express? And using that same instance name? ---
**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:** [January 22, 2020, 3:03pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/5 "2020-01-22T15:03:07Z")
Are you sure your SQL Server instance is actually running and configured to bind to localhost and the same port? ---
**Author:** ![qliu](https://avatars.discourse-cdn.com/v4/letter/q/bc8723/32.png) [@qliu](https://forum.inductiveautomation.com/u/qliu)\ **Post date:** [February 11, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/6 "2021-02-11T17:53:57Z")
Hi, is there any update for this issue? I have the same issue happened yesterday, thanks! ---
**Author:** ![m.boog](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Post date:** [February 11, 2021, 6:09pm UTC](https://forum.inductiveautomation.com/t/ms-sql-database-connection-issue/31511/7 "2021-02-11T18:09:38Z")
Sorry, no good solution from my end. As memory serves, I left the job site and everything worked, so I didn’t have reason to revisit the issue.