Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 JDBC URL format for SQL Server 2012 SSL Modes

Author  Topic 

OxKing033
Starting Member

2 Posts

Posted - 2014-07-23 : 16:27:04
Hi Everyone,

This is my first post on the forum! My question relates to the JDBC Url used to connect to SQL Server 2012.

Currently, I wanted to connect to the SSL JDBC URL with these options:

SSL OFF MODE
SSL REQUEST MODE
SSL REQUIRED MODE

right now, my url is this format:

jdbc:sqlserver://localhost:1433;databaseName=test;encrypt=true;trustServerCertificate=true;


I know that encrypt=false would be the equivalent of SSL OFF MODE.
and encrypt=true would be the equivalent of SSL REQUIRED MODE.

But which set of connection properties would relate to SSL REQUEST MODE?

What i mean by request mode is that suppose the client requests connecting to the sql server via SSL but that server doesn't support SSL Encryption and will then connect in non-SSL Mode.


I tried ssl=request and encryptionMethod=sslRequest but neither seemed to be recognized.

The driver i'm using is:
com.microsoft.sqlserver.jdbc.SQLServerDriver


Suggestions? :)

Thanks

OxKing033
Starting Member

2 Posts

Posted - 2014-07-25 : 14:49:53
Looks like I had to use the JTDS driver. Figured it out.

Thanks though,

OxKing033
Go to Top of Page
   

- Advertisement -