# SQL Bridge Connection Error **URL:** \ **Category:** Ignition\ **Created:** [September 23, 2024, 6:08pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316 "2024-09-23T18:08:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Elmer\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/e/c89c15/32.png) [@Elmer\_Sanchez](https://forum.inductiveautomation.com/u/Elmer_Sanchez)\ **Post date:** [September 23, 2024, 6:08pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/1 "2024-09-23T18:08:35Z")
I'm having no luck when it comes to connecting to a Microsoft SQL Database. This is the error I'm having, and the server is running, TCP ports 1433 and 1434 are not blocked. Any help is definitely appreciated. Cannot create PoolableConnectionFactory (The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".) ---
**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Post date:** [September 23, 2024, 6:15pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/2 "2024-09-23T18:15:17Z")
What version of Microsoft SQL server are you using? If you are using the free version you have to explicitly enable TCP connections. If you are using the full version, then there might be a firewall in between your SQL server and your Ignition server that is blocking the connection attempt. ---
**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:** [September 23, 2024, 6:16pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/3 "2024-09-23T18:16:38Z")
> [@Elmer\_Sanchez](#): > > localhost Are you running the DB on the same machine as Ignition? If not, then `localhost` is definitely the wrong hostname. If you are, consider **not** , particularly if this is for a production system. ---
**Author:** ![Elmer\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/e/c89c15/32.png) [@Elmer\_Sanchez](https://forum.inductiveautomation.com/u/Elmer_Sanchez)\ **Post date:** [September 23, 2024, 6:19pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/4 "2024-09-23T18:19:28Z")
The free version(Developer). Enable TCP connections for the SQL server through Configuration Manager? Because I have: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a2f96c7899db9a0c8f49c98627c1e64acd5da0d.png) ---
**Author:** ![Elmer\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/e/c89c15/32.png) [@Elmer\_Sanchez](https://forum.inductiveautomation.com/u/Elmer_Sanchez)\ **Post date:** [September 23, 2024, 6:20pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/5 "2024-09-23T18:20:32Z")
I'm running the database from my computer and the Ignition is running on a different computer. ---
**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Post date:** [September 23, 2024, 6:21pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/6 "2024-09-23T18:21:35Z")
> [@Elmer\_Sanchez](#): > > Ignition is running on a different computer. See: > [@pturmel](#): > > If not, then `localhost` is definitely the wrong hostname. Your connection string in ignition would need to start with your computer's IP or hostname, not `localhost`. ---
**Author:** ![Elmer\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/e/c89c15/32.png) [@Elmer\_Sanchez](https://forum.inductiveautomation.com/u/Elmer_Sanchez)\ **Post date:** [September 23, 2024, 6:39pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/7 "2024-09-23T18:39:13Z")
That fixed the problem. Thank you! ---
**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 23, 2024, 6:41pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-connection-error/96316/8 "2024-09-23T18:41:43Z")
Don't forget to hit the **Solution** link below the post that solved your problem.