How to handle No suitable driver found error during MSSQL connection establishment

This article provides step by step instructions on how to handle No suitable driver found error while establishing MSSQL connection with confluence instance using SQL for Confluence (Pro Edition) app.

Instructions

1. Log into Confluence as an administrator.
2. Click the Cog menu > Manage apps.
3. Expand app, Bob Swift Atlassian Add-ons - SQL (Pro Edition).
4. Click Configure to see the configuration page.
5. Select the View and modify data source profiles tab.
6. To create a data source profile, click the Add profile button.

7. Provide the following parameters along with other required details while creating a profile:

   Connection String for MSSQL database:

   jdbc:sqlserver://<hostname>:1433;databaseName=<database-name>

   Driver class:

   com.microsoft.sqlserver.jdbc.SQLServerDriver

   Driver Jar location:

   <Confluence-Installation-Directory>/Confluence/WEB-INF/lib/<mssql-jdbc-x.x.x.jar>

   To download the required jar file, navigate to this URL: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15 and place the jar file in this location: <Confluence-Installation-Directory>/Confluence/WEB-INF/lib.

   In general, Confluence provides the MSSQL JDBC jar and it is under <Confluence-Installation-Directory>/Confluence/WEB-INF/lib.

8. Click the Test connection button. Once the connection is successfully established, you see this message: Connection successful.

9. Click Next and Save profile. MSSQL connection is set for your confluence instance properly and it resolves the No suitable driver found error.