JDBC URL format for SQL Server 2012 SSL Modes

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources