# Unable to connect to SQL Server 2000 **URL:** \ **Category:** Ignition\ **Tags:** database, ignition80\ **Created:** [January 14, 2021, 3:53pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247 "2021-01-14T15:53:55Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![gfeiten](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@gfeiten](https://forum.inductiveautomation.com/u/gfeiten)\ **Post date:** [January 14, 2021, 3:53pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/1 "2021-01-14T15:53:55Z")
I am having the same issue with version 8.1.1 connecting to a SQL server 2000 database. One thing I noticed is there is not a java.security file in the security folder, just a java file. It contained the referenced configuration ( 3DES\_EDE\_CBC from the jdk.tls.disabledAlgorithms ) so I am guessing it is the equivalent file. I made the update, restarted Ignition, and still have the same error. Message is: java.sql.SQLException: Cannot create PoolableConnectionFactory (SQL Server version 8 is not supported by this driver. ClientConnectionId:1358887e-db2a-4609-a912-c59eafbdeed7) Any other ideas? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [January 14, 2021, 4:13pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/2 "2021-01-14T16:13:31Z")
I don’t think that any recent SQL Server JDBC drivers support SQL Server 2000. Microsoft maintains some compatibility matrices here: [https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15) ---
**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:** [January 14, 2021, 6:11pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/3 "2021-01-14T18:11:19Z")
I had to use jTDS. > [@java.sql.SQLException after migration 7.9 to 8.1 and with SQL Server 2005 Database Connection](http://forum.inductiveautomation.com/t/java-sql-sqlexception-after-migration-7-9-to-8-1-and-with-sql-server-2005-database-connection/41526/2): > > The newer versions of the jdbc driver dropped support for the older versions. I ended up using jTDS for those. [https://sourceforge.net/projects/jtds/files/](https://sourceforge.net/projects/jtds/files/) EDIT: The reason I went this route was that M$ (bless their hearts) obfuscated download locations of their earlier versions of jdbc drivers, and I still needed to connect to later instance versions as well. So I added it as a separate driver. ---
**Author:** ![gfeiten](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@gfeiten](https://forum.inductiveautomation.com/u/gfeiten)\ **Post date:** [January 14, 2021, 8:02pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/4 "2021-01-14T20:02:11Z")
We have a winner, Thank you!!! ---
**Author:** ![pphillips](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Post date:** [May 28, 2021, 7:25pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/5 "2021-05-28T19:25:46Z")
I had a similar issue with MSSQL v10, Server 2008 R2 going to Ignition v8.1.6 from v7.9.14. Updated the driver to MSSQL JDBC v7.2.2 for jre11 and kept getting the following error: `"The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]"` The SQL server (which I cannot modify) was apparently requesting TLS1.0 encryption, but the driver refused. Adding the connection parameter “sslProtocol=TLSv1” (and anything else) did not help. Deleting `"TLSv1"` and `"TLSv1.1"` from `jdk.tls.disabledAlgorithms` in the _java.security_ file appears to fix it. In Linux, file _java.security_ is located in: `/usr/local/bin/ignition/lib/runtime/jre-nix/conf/security/` ---
**Author:** ![vipo](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vipo](https://forum.inductiveautomation.com/u/vipo)\ **Post date:** [June 9, 2021, 11:59am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/6 "2021-06-09T11:59:43Z")
This also worked for me ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [June 15, 2021, 5:06pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/7 "2021-06-15T17:06:15Z")
Just upgraded from V8.1.3 to V8.1.7 and we lost one of our database connections: `Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:108f0d77-e759-49c6-af8b-0b6697a9d005)` Going to go back to V8.1.3… ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [June 15, 2021, 5:16pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/8 "2021-06-15T17:16:39Z")
Once the V8.1.7 → V8.1.3 installation was complete the connection became valid again… ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [June 15, 2021, 5:18pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/9 "2021-06-15T17:18:40Z")
8.1.7 deprecates TLS 1.0 and 1.1 due to an upgrade in our bundled Java version, as [mentioned in the changelog](https://inductiveautomation.com/downloads/releasenotes/8.1.7#16993) and the [user manual](https://docs.inductiveautomation.com/display/DOC81/New+in+this+Version#NewinthisVersion-Newin8.1.6). ---
**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:** [June 15, 2021, 7:17pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/10 "2021-06-15T19:17:41Z")
See also this topic for a work-around; > [@SQL Server Connection Faulted](http://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393): > > After replacing a development installation of Ignition 8.1 with 7.9.17, I am suddenly unable to communicate with my local SQL server. The connection was fine before the reinstall but now it’s faulted and showing this error: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)”.) I’ve double checked all t… ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [June 15, 2021, 7:17pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/11 "2021-06-15T19:17:57Z")
Rather than downgrading Ignition’s TLS preferences you should prefer upgrading or patching your SQL Server instances: [Zulu64 JRE and Database Connection Faults - #2 by Kevin.Herron](http://forum.inductiveautomation.com/t/zulu64-jre-and-database-connection-faults/47152/2) ---
**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:** [June 15, 2021, 7:19pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/12 "2021-06-15T19:19:45Z")
No patches for anything older than SQL Server 2008. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [June 15, 2021, 7:31pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/13 "2021-06-15T19:31:34Z")
☹ ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [June 16, 2021, 2:47pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/14 "2021-06-16T14:47:03Z")
Hi guys, this morning I upgraded both master and backup gateway from V8.1.3 to V8.1.7 then on the master, removed TLSv1 and TLSv1.1 from line 729 of the java.security file and restarted the gateway. Master now has a valid connection to the previously connection faulted database. Unfortunately, when I go to the backup gateway, the connection is still faulted. I restarted the backup - no change. I then assumed I needed to edit the same file on the backup and did so then restarted it. It says the gateway is running but I cannot access it and when I go to the master gateway it says the peer is not connected. I reverted back to the old java.security file and restarted and everything is back up as normal except the backup still does not have a valid connection to the previously connection faulted database… ---
**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:** [June 16, 2021, 3:26pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/15 "2021-06-16T15:26:09Z")
Any chance of a typo when editing the backup’s `java.security` file? Maybe copy the working one from the master to the backup? ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [June 16, 2021, 3:30pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/16 "2021-06-16T15:30:24Z")
I was thinking the same thing and had a look at each file and they look identical. Thought I would post to the forum just incase it could be something else I was missing. Ok, will try copying over the master’s file and restarting. ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [June 16, 2021, 3:35pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/17 "2021-06-16T15:35:59Z")
That did the trick, thanks @pturmel! ---
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [December 30, 2021, 7:35am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/18 "2021-12-30T07:35:12Z")
Hi Jordan I have the same issue ,my SQL server is 2008 version. When I update from 8.1.0 to 8.1.13 some database lost connection(that database is our ERP database base on another server) I have try the solution you have mentioned, here is the picture Step1: download the jdts ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/0/80c5e9d5ff1ccaf17a9c220ed9fd6071319b5535.png) Step2: Save on the document ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7eb32f097a5489be52df44bcded332ccc1cf81f3.png) Step3: according the manual update the file and save ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/7/a76f6a9f11269a128e05b96c34ecf1b2a123e688.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/9/d9af0084eb28350cfe64c9fe7323d1f0165d1158.png) Still not OK Can you tell me which step I have make a mistake ---
**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:** [December 30, 2021, 6:19pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/19 "2021-12-30T18:19:53Z")
Take a closer look at the settings I posted. The URL Format, in particular. ---
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [December 31, 2021, 3:24am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247/20 "2021-12-31T03:24:24Z")
It works, thanks a lot ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/2/02ec74d062d5ab32b3b87014e54dbca1564ef3cd.png) [Next page](https://forum.inductiveautomation.com/t/unable-to-connect-to-sql-server-2000/42247.md?page=2)