# I can 't connect the database to ignition

**URL:** <https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978>\
**Category:** Ignition\
**Tags:** database\
**Created:** [December 10, 2021, 12:05am UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978 "2021-12-10T00:05:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Rangel](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@Alejandro\_Rangel](https://forum.inductiveautomation.com/u/Alejandro_Rangel)\
**Post date:** [December 10, 2021, 12:05am UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/1 "2021-12-10T00:05:04Z")

</div>

I am using the demo version to validate the communication of a new PLC with this SCADA software. But I am having trouble connecting a database to Ignition that stores historical data from a PLC. I have followed all the instructions in the manual at this link:

[https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-DifferentWaysofConnectingtoSQLServer](https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-DifferentWaysofConnectingtoSQLServer)

But I have not been successful. Constantly the status of the connection is trying to connect but it always ends in error and displays the following error message:

Cannot create PoolableConnectionFactory (Failed to make TCP / IP connection to host localhost, port 1433. Error:  
"Connection timed out: no more information … Check connection properties, check  
that there is an instance of SQL Server running on the host and accepting TCP / IP connections on the port and check that it is not  
There is no firewall blocking TCP connections on the port. ".)

I hope someone can support me.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 10, 2021, 12:09am UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/2 "2021-12-10T00:09:43Z")

</div>

Welcome!

> [@Connected to SQL Server Express failied](https://forum.inductiveautomation.com/t/connected-to-sql-server-express-failied/53768):
>
> Hello, I am a developer of Oasys HMI developer and like to expend my career to ignition. I download software and try it out on my windows 10 first time. I got following error after installed JRE, copied unzipped JDBC driver C:\Program Files\Microsoft JDBC DRIVER 9.4 for SQL Server to from [Download - JDBC Driver for SQL Server | Microsoft Docs](https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15) (I could not find exe installation version) Any problem solving process I could follow up? My SQL server instance called “DESKTOP-ENHKM1F\SQLEXPRESS”. …

hope this helps!

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [December 10, 2021, 1:46pm UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/3 "2021-12-10T13:46:17Z")

</div>

I had the same problem for a while and then I fixed it based on these links. I also created a new login user for only that database so that I can use it with Ignition only (I put the link below).  
If you did everything that the manual said, my recommendation is to create a new login.

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/4478137ae9152c8c78973f1a133839f24195ccdb.jpeg "Allow remote connections to SQL Server Express : How to Video") ](https://www.youtube.com/watch?v=5UkHYNwUtCo)

[https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition](https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition)

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/2/42a245d5bba1faf7da9e9b2459bba6ff81a5cd88.jpeg "How to Create a new Login in Microsoft SQL Server 2019") ](https://www.youtube.com/watch?v=qfuK0V1tlrA)

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/227620a2faaa79af6ca4aa251b8cf8cbca944598.jpeg "Microsoft SQL Server - Create Login Account") ](https://www.youtube.com/watch?v=jkCH_nfd8oI)

---

<div class="post-metadata">

**Author:** ![Alejandro\_Rangel](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@Alejandro\_Rangel](https://forum.inductiveautomation.com/u/Alejandro_Rangel)\
**Post date:** [December 10, 2021, 5:44pm UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/4 "2021-12-10T17:44:13Z")

</div>

Matrix\_ Engineering.

Thanks for your support.!

---

<div class="post-metadata">

**Author:** ![Alejandro\_Rangel](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@Alejandro\_Rangel](https://forum.inductiveautomation.com/u/Alejandro_Rangel)\
**Post date:** [December 10, 2021, 5:47pm UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/5 "2021-12-10T17:47:11Z")

</div>

pkhoshroo…

Thanks for your support.  
I fix my problem creating a new loggin to connect Ignition.

😀

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [December 10, 2021, 5:58pm UTC](https://forum.inductiveautomation.com/t/i-can-t-connect-the-database-to-ignition/53978/6 "2021-12-10T17:58:12Z")

</div>

Awsome! Glad you could fix it 🙂
