How to handle the "No suitable driver found" error when connecting to an MS-SQL database

This article provides step-by-step instructions on how to handle the "No suitable driver found" error. This error usually occurs while establishing an MS-SQL connection with Confluence using the SQL for Confluence (Pro Edition) app.

Instructions

1. Log into Confluence as an administrator.

2. Click the Cog menu

    > Manage apps.

3. Expand the Bob Swift Atlassian Add-ons - SQL (Pro Edition) app.

4. Click Configure to see the configuration page.

5. Select the View and modify data source profiles tab.

6. Click Add profile to create a data source profile.

7. Provide the following parameters and other required details while creating the profile:

8. Click Test connection. Once the connection is successful, you get the "Connection successful" message.

9. Click Next and Save profile.

The MS-SQL connection is now set for your Confluence instance without the driver error.