Getting error while connecting SQL Database. How to use JDBC to connect Azure SQL Database

Question

Getting error while connecting SQL Database. How to use JDBC to connect Azure SQL Database

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

Welcome to Microsoft Q&A forum.

You can download latest JDBC package from https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16

For the connection string, you can refer to Building the connection URL - JDBC Driver for SQL Server | Microsoft Learn.

For the properties in connection string, you can refer to Setting the connection properties - JDBC Driver for SQL Server | Microsoft Learn

 The class should be “com.microsoft.sqlserver.jdbc.SQLServerDriver”

Thank You!