Connect to SQLServer TLS 1.2 using DbVisualizer and SSMS

Simple steps to connect to Microsoft SQL Server which has TLS 1.2 enabled.

1 : Connect via SSMS

Step 1 : Server Name : Enter Server Name in full
example : hostname.company.com

Step 2 : Enter Login / Password for SQL Server Authentication

Step 2a : For windows use Windows Authentication

Step 3: Click OPTIONS >>

Step 4 : Go to Connection Properties Tab and Check “Encrypt Connection”

Step 5 : Click Connect, now you are connected.

2. Connect via DBVis

Step 1 :

Download Microsoft JDBC Driver for SQL Server. (https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15)

Preferably download the .gz version.

Unzip the .gz file and untar the .tar file

Copy the
mssql-jdbc-7.4.1.jre8.jar,
mssql-jdbc-7.4.1.jre11.jar,
mssql-jdbc-7.4.1.jre12.jar

(whatever latest version you downloaded on step 1) to default jdbc directory (C:\users\username.dbvis\jdbc)

Step 2 :

Select Drive (JDBC): SQL Server (Microsoft JDBC Driver) not the default jTDS

If driver not available DBViz will prompt you to load the driver in a folder. If Step 1 is done right this should work without issues.

Step 3:

Database Sever : Enter full HOST Name (example : host.company.com)
Database Port : 1433 (default). If its changed by DBA use that.
Database :
Instance : If SQL Server has specific Instance enter full instance name (instance.company.com) else (host.company.com)
Database User ID :
Database Password:
Permission Mode : Development / Production based on the server.

Step 4 :

Go to Properties Tab

Click on Driver Properties

and check sslProtocol and type TLSv1.2

Click OK and Connect.

Now DB Visualizer will be able connect to TLS 1.2 enabled SQL Server .

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: