Problem of connection to the SQL database

[Davit (Archuadze)]

Hello , I use Sonarqube Developer Edition version 10.3.0.82913 on windows server 2019 standart , when i try to connect SQL databases with active directory user , error is :

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:4026)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:74)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:5098)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:5087)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3583)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3172)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3014)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1836)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1246)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
… 53 common frames omitted
Caused by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-12.4.1.x64
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:63)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:5097)
… 66 common frames omitted

this mssql-jdbc_auth DLL is locate in C:\Windows\System32 and this path added in System variables .

My connection string looks like:

sonar.jdbc.url=jdbc:sqlserver://IP;databaseName=sonar;integratedSecurity=true
user and password - commented

Local users have no connection problem and also when I test the connection from SQL Server Management with Active Directory user it works.

how can i achieve windows authentication to SQL database?

Thanks,

[anon67236913]

Welcome

@Davit

sonar.jdbc.url=jdbc:sqlserver://IP;databaseName=sonar;integratedSecurity=true
user and password - commented

your sonar.jdbc.url looks good, but you need no user and password when using
integrated security.

The sonar.properties has also this comment
# Do not set sonar.jdbc.username or sonar.jdbc.password property if you are using Integrated Security

Are you sure, you’re using the 64bit dll with the correct version ?
Maybe there’s another dll with older version from a former Sonarqube installation on PATH.
The safest location to put the dll, is the /bin folder of your Java Sonarqube runs on.

Gilbert

[Davit (Archuadze)]

Thank you Gilbert ,

You were right, I had a different version of mssql-jdbc-12.6.2.jre11.jar