SQL Bridge Connection Error

Ignition
1

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.".)

2

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.

3

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.

2 Likes
4

The free version(Developer). Enable TCP connections for the SQL server through Configuration Manager? Because I have:
image

5

I'm running the database from my computer and the Ignition is running on a different computer.

6

See:

Your connection string in ignition would need to start with your computer's IP or hostname, not localhost.

1 Like
7

That fixed the problem. Thank you!

8

Don't forget to hit the Solution link below the post that solved your problem.