The latest jdts driver have the ability to do SSO on MSSQL using the same service account that is running Confluence service, however the bundled version we ship on Confluence does not cover that area.

Step-by-step guide

To make Confluence use Single Sign On against MSSQL database you need to do the following: 

1. Go to JTDS download page and download the latest version of the driver (the zip file).
2. Open the zip file, you will see two folder x64 and x86.
3. Open the one that corresponds your Confluence installation.
4. Now open the SSO folder and copy the ntlmauth.dll to a temporary directory.
5. Click on Start > CMD and navigate to <Confluence Install>\bin directory.
6. Follow steps 1 to 5 of this guide.
7. In the java tab check the path under "Java Virtual Machine"

8. Navigate to your the JRE\BIN directory on above path and drop the ntlmauth.dll

   In case your Confluence instance is not installed as a service just check the JAVA_HOME path and drop the ntlmauth.dll in the <JAVA_HOM>\bin directory.

9. Shutdown Confluence.
10. Make sure that the account that runs Confluence have all the proper permissions on Confluence database.
11. Edit the <Confluence Home>\confluence.cfg.xml file.

12. Search for the following:

    <property name="hibernate.connection.password">DbUserPass</property>
    <property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/dummy;</property>
    <property name="hibernate.connection.username">DatabaseUser</property>

13. Add ";useNTLMv2=true;domain=MyDomain" at the end of the  connection URL. It will look like the following:

    <property name="hibernate.connection.password">DbUserPass</property>
    <property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/dummy;useNTLMv2=true;domain=MyDomain</property>
    <property name="hibernate.connection.username">DatabaseUser</property>

14.  Now remove the hibernate.connection.password and hibernate.connection.username lines. It will look like the following:

    <property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/dummy;useNTLMv2=true;domain=MyDomain</property>

15. Save the file.

16. Start Confluence.

    In case this is your first installation first follow this guide and once Confluence is full installed then try the steps listed in here.

Related articles