How to handle the error: No suitable driver found while connecting to MS-SQL database

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 in to Confluence as an administrator.
2. Click the Cog menu > Manage apps.
3. Expand the 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 Add profile.

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 JDBC jar for MS-SQL. It is under <Confluence-Installation-Directory>/Confluence/WEB-INF/lib.

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

9. Click Next and Save profile. MS-SQL connection is set for your confluence instance and it resolves the error: No suitable driver found.