Versions Compared

Version Old Version 9 New Version Current
Changes made by

Amith Mathur

Smita Nair

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 the "No suitable driver found" error. This error usually occurs while establishing MSSQL an MS-SQL connection with confluence instance Confluence using the SQL for Confluence (Pro Edition) app.

Instructions

  1. Log in to into Confluence as an administrator.
  2. Click the Cog menu > Manage apps.
  3. Expand the app, 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. To Click Add profile to create a data source profile, click Add profile.

  7. Provide the following parameters along with and other required details while creating a the 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: <Confluencethe <Confluence-Installation-Directory>/Confluence/WEB-INF/lib location.

    In general, Confluence provides the JDBC jar for MS-SQL. It is under <Confluence-Installation-Directory>/Confluence/WEB-INF/lib.Note:

    Note
    • The port number may vary according to your database set-up. 
    • As per Atlassian, the open source jTDS driver for Microsoft SQL Server
    will
    • is not
    be
    • supported for use
    with Confluence
    • beyond Confluence 6.5. This means you
    will
    • need to switch to using the official Microsoft JDBC Driver for SQL Server, which is bundled with Confluence 6.4 and later.
     



  8. Click Test connection. Once the connection is successful, you see this message: 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.