# SQL Server did not return a response

**URL:** <https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161>\
**Category:** Ignition\
**Tags:** database\
**Created:** [November 30, 2018, 4:06pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161 "2018-11-30T16:06:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![francisco.romero](https://avatars.discourse-cdn.com/v4/letter/f/91b2a8/32.png) [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\
**Post date:** [November 30, 2018, 4:06pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161/1 "2018-11-30T16:06:43Z")

</div>

Hi  
We are using Ignition version 7.9.8 (b2018060714) with java 1.8.0\_171-b11 and Windows Server 2016  
We are trying to connect to SQL Server, I am using the sa account.

We get the following error:  
Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.".)  
So far we checked the forum and followed the instructions in this topic:

> [@Windows 7 MSSS2008 First time set up](http://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/5):
>
> Showing that these topics no longer exist. I would like to see this work step.

But still isn’t working.

I also checked this topic [Ignition cannot connect to SQL Server - #3 by pgmo](http://forum.inductiveautomation.com/t/ignition-cannot-connect-to-sql-server/18842/3) but that didn’t work for me

My connection string is as follows  
jdbc:sqlserver://localhost\MSSQLSERVER:1433

I read another topic ([SQL connection - #6 by Colby.Clegg](http://forum.inductiveautomation.com/t/sql-connection/3606/6)) which mentions downgrading the java jre. But this might affect other applications as well.

Is there any other possibility to make this works?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 30, 2018, 4:50pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161/2 "2018-11-30T16:50:18Z")

</div>

You didn’t mention what version of SQL Server you were using, but I recommend using the latest JDBC driver:

[https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server](https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server)

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [November 30, 2018, 5:52pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161/3 "2018-11-30T17:52:51Z")

</div>

Also make sure the SQL Server Browser service is running on the server.

---

<div class="post-metadata">

**Author:** ![francisco.romero](https://avatars.discourse-cdn.com/v4/letter/f/91b2a8/32.png) [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\
**Post date:** [November 30, 2018, 6:25pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161/4 "2018-11-30T18:25:07Z")

</div>

I had installed the 6.0 I thought that one was the latest. Your link was very helpful, I installed 7.0 and followed the instructions in this post [Windows 7 MSSS2008 First time set up](http://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683/4) (The ones from Robert McKenzie) and it works now.

I think it would be very helpful to put this info in the [docs.inductiveautomation.com](http://docs.inductiveautomation.com)

Thanks for your help!