Add Profile for Microsoft SQL Server using SQL for Confluence

This article provides steps for pre-checking the connection and instructions to add a profile with database type - Microsoft SQL Server.


If you are observing the below error in the log (atlassian-confluence.log) files, perform the pre-checks that are mentioned below:

driverClass :
dbJar : /atlassian/sqlDrivers/sqljdbc4x.jar
dburl : jdbc:sqlserver://hostnameorIP:port;database=DbName
username : user
dataSourceName :
caused by: javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
caused by: java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter


  1. If the Confluence instance is upgraded to any of the latest versions, i.e.,7.13.1 or higher, ensure the old( before upgrade) and new (after upgrade) Java files are not in the same place. If the files are located in the same place, then stop the Confluence, remove old files and restart the Confluence.

  2. Make sure the plugin is up-to-date.
  3. Use the maven link in the Driver JAR location instead of the path to the driver jar. The compatible jar versions are available here: Navigate to the respective jar version, use the link, and test the connection. If it works, then download the jar version from the same maven link and place it under the /<confluence-Installation-directory>/confluence/WEB-INF/lib. 
  4. If you still observe the error as shown in the picture, then follow the below given instructions:

  1. Add the below JVM parameter line in file under: <Confluence_installation_directory>/bin/ or <Confluence_installation_directory>/bin/setenv.bat, if it is Windows.

    CATALINA_OPTS="-Dadd-modules=java.xml.bind ${CATALINA_OPTS}"
  2. After adding this entry, restart the Confluence and validate the SQL Pro profile against your SQL Server database.
  3. If you are still facing an issue, and your current java version is 1.11, then make it to 1.8 and re-check the connection.

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.