Versions Compared

Version Old Version 7 New Version 8
Changes made by

Former user

SriRama Batta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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 the Add profile button.

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

    Panel

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


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

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