Robert Timmons
asked on
Microsoft JDBC driver permissions
I have an application that started trying to connect to the SQL server using SSL after restart. Is there a security setting or permission deployment for java that would make the JBBC driver request connections use SSL. The connection was working fine for several months and I can still connect using ODBC
The error I get is:
:[trycatch] Caught exception: com.microsoft.sqlserver.jd bc.SQLServ erExceptio n:
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.".
[echo] ERROR: com.microsoft.sqlserver.jd bc.SQLServ erExceptio n: The driver
could not establish a secure connection to SQL Server by using Secure Sockets Lay
er (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.".
The error I get is:
:[trycatch] Caught exception: com.microsoft.sqlserver.jd
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.".
[echo] ERROR: com.microsoft.sqlserver.jd
could not establish a secure connection to SQL Server by using Secure Sockets Lay
er (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that is why I gave you the link so you can look at how it is making the connection and whether or not your SQL server is requiring SSL for the queries.
ASKER
SQL is not set to force encryption
okay, now look the jdbc command string to ensure it doesn't require encryption as well.
ASKER
The connection string does not include encryption settings either. The application connected just fine for months and no changes made to application. That why I am stumped as too why it is trying to connect SSL after a restart
are you sure there isn't another connection string? It shouldn't be trying to connect with SSL if it is not being told to.
ASKER
I went to the team that wrote the application and they tell me there is nothing that would make it try to connect SSL and that it must be infrastructure. The only other time I ran into this problem with this particular application was when FIPS was enabled because the JDBC drive is FIPS aware but once I turned FIPS off then the issue went away but I have triple checked that FIPS is not enabled. The parameters of the connection string are below. I checking now to see if there is any other app on the machine that is using java
<db-connection name="XXXXX">
<url>jdbc:sqlserver://serv ername:143 3;Database =CORE_Scru b;Applicat ionName=HM S;LoginTim eout=300</ url>
<driver>com.microsoft.sqls erver.jdbc .SQLServer Driver</dr iver>
<user>HMS</user>
<password>FpuS7WwhbegupK+/ yHaniQ\=\= </password >
<min-size>80</min-size>
<max-size>100</max-size>
<idle-timeout-minutes>1</i dle-timeou t-minutes>
</db-connection>
<db-connection name="XXXXX">
<url>jdbc:sqlserver://serv
<driver>com.microsoft.sqls
<user>HMS</user>
<password>FpuS7WwhbegupK+/
<min-size>80</min-size>
<max-size>100</max-size>
<idle-timeout-minutes>1</i
</db-connection>
You are right, there is nothing in that string that tells it to try SSL. But the app is trying an SSL connection. I would look at the code and verify that is the only JDBC code in app. It doesn't make sense other wise.
ASKER
I've requested that this question be deleted for the following reason:
Found my own solution
Found my own solution
ASKER