Database Setup Microsoft SQL 2012 for Confluence 6.15.6 ( Error SQLState - 08S01)

[Viktor.Sykov]

Hello,

Confluence installed on Ubuntu Server 18.04. I want to use my database Microsoft SQL 2012.

The following settings have been made on the Confluence server:

1. Stop Confluence

2. Download sqljdbc_7.2.2.0_enu.tar unpacked and copied the file mssql-jdbc-7.2.2.jre8.jar to / confluence / WEB-INF / lib

3. Added content to /confluence/conf/server.xml 

<Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
username="username"
password="pass"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://0.0.0.0:1433;database=confluence"
maxTotal="60"
maxIdle="20"
validationQuery="select 1"/>

4. Added content to confluence.cfg.xml file: 

<property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> 
<property name="hibernate.connection.url">jdbc:jtds:sqlserver://0.0.0.0/confluence</property> 

5. To connect to the database using the string:

jdbc:sqlserver://0.0.0.0;instanceName=nameinstance;databaseName=confluence;integratedSecurity=true

 

 6. Server Confluence and database are available, ping.

7. From server Confluence I connect via telnet port 1433 Microsoft SQL

8. Firewall settings are correct, services Confluence & MS SQL are not blocked

9. Database set up according to - https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html

10. I get an error when trying to connect:

SQLState - 08S01
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:30a749fc-0aeb-4da2-9dfc-4762fa7229dd

[Nic Brough -Adaptavist-]

Why are you doing this instead of just following the doc you link to in step 9?