Confluence not starting getting error Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in

[Cymax Support]

Hi

I am trying to build a staging environment on a Windows Server  and have downloaded the zip file for confluence 7.91 and copied our confluence-home folder across and gone through all the configuration files and updated them

I downloaded and extracted the following JAVA and also added them to the System Environmental section in Windows

OpenJDK11U-jre_x64_windows_hotspot_11.0.7_10

OpenJDK11U-jdk_x64_windows_hotspot_11.0.7_10

We use Integrated Auth for our MS SQL Server Database

But I am getting the following Error in the atlassian-confluence log file when I start the confluence Service.

Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path: [E:\Confluence_Staging\atlassian-confluence-7.9.1\bin, C:\Windows\Sun\Java\bin, C:\Windows\system32, C:\Windows, E:\_Apps\jdk-11.0.7+10-jre\bin, C:\Windows\system32, C:\Windows, C:\Windows\System32\Wbem, C:\Windows\System32\WindowsPowerShell\v1.0\, C:\Windows\System32\OpenSSH\, C:\Program Files\Microsoft\Web Platform Installer\, C:\Users\00005_Confluence\AppData\Local\Microsoft\WindowsApps, .]
at java.base/java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.base/java.lang.Runtime.loadLibrary0(Unknown Source)
at java.base/java.lang.System.loadLibrary(Unknown Source)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:50)
... 31 more
2020-12-09 14:16:41,175 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2020-12-09 14:16:45,003 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2020-12-09 14:16:57,097 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext initialized in 15922 ms
2020-12-09 14:17:41,193 ERROR [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent Database connection failed
2020-12-09 14:17:41,193 ERROR [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent Confluence failed to establish a connection to your database.
This could be because:
- Your database isn't running
- The configuration of your confluence.cfg.xml file is incorrect (user, password, or database URL etc.)
- There is a network issue between Confluence and your database (e.g. firewall, database doesn't allow remote access etc.)

Any help would be appreciated to resolve this issue.

Matthew

[Fabian Lim]

Hi @Cymax,

I found this KB article that may help resolve your issues. Link: https://confluence.atlassian.com/confkb/synchrony-failed-to-load-the-sqljdbc_auth-dll-cause-no-sqljdbc_auth-in-java-library-path-948239334.html

Regards