# Error on database connection **URL:** \ **Category:** Ignition\ **Tags:** database, ignition81, vision\ **Created:** [October 9, 2023, 8:17pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230 "2023-10-09T20:17:26Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Post date:** [October 9, 2023, 8:17pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/1 "2023-10-09T20:17:26Z")
Hello everyone I need connect a new database connection whit SQL sever locally , I setting the conection but I recibet the next error " ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/e/be8e770b0c11cfbac645eb70719e5c3b9d62b88f.png) " I configurate the TCP/IP properties ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/f/dfa2f3c27cc2ec38377eb17c77505f73a70a7afa.png) this is my conection ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0cd0e445b54e4bd3308e0281ebb4388e21bcc74c.png) ---
**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:** [October 9, 2023, 8:22pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/2 "2023-10-09T20:22:08Z")
What version of SQL Server are you using? Double-check that you have all the configuration correct. [https://www.sqlshack.com/sql-server-network-configuration/](https://www.sqlshack.com/sql-server-network-configuration/) ---
**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:** [October 9, 2023, 8:28pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/3 "2023-10-09T20:28:46Z")
"Connection refused" That is a pure networking error, typically caused by nothing listening on the target **port** , but sometimes also caused by firewall rules. Double check your IP addresses, listening ports, and firewalls. ---
**Author:** ![mvenegas](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@mvenegas](https://forum.inductiveautomation.com/u/mvenegas)\ **Post date:** [October 9, 2023, 8:32pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/4 "2023-10-09T20:32:05Z")
Hi, Antonio, I usully enable the TCP/IP protocol. like in this image. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a34cd8c7cf8602c56fcf7b7822cf18f3a4161b95.png) And make sure to open 1433 port in your firewall. Can you connect to the database using other client? like sql server management studio? ---
**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Post date:** [October 9, 2023, 10:22pm UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/5 "2023-10-09T22:22:12Z")
I have used the SQL server 2022,This is a local connection, yes I can connect used the user sa on management studio ---
**Author:** ![mvenegas](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@mvenegas](https://forum.inductiveautomation.com/u/mvenegas)\ **Post date:** [October 11, 2023, 12:26am UTC](https://forum.inductiveautomation.com/t/error-on-database-connection/80230/6 "2023-10-11T00:26:14Z")
Hi, Have you tried the settings show in the documentation? [Connecting to Microsoft SQL Server - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server)[MSSQL Settings](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server)