Installing JIRA with SQL Server 2005 Fails due to 'Native SSPI Library not Loaded' Error
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
JIRA running with SQL Server 2005 fails to start up, throwing the following error in the logs:
1
2
3
4
5
6
7
8
9
10
11
2008-09-13 10:13:24,956 Thread-1 ERROR [jira.appconsistency.db.DatabaseConsistencyCheck] There was a SQL exception checking for database driver correctness. Skipping.
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
......
Caused by: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:614)
... 25 more
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1889)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:587)
... 32 more
Cause
There are 2 possible causes spawning from your Windows environment:
The JTDS driver is not working with Windows Authentication because the driver requires native libraries to perform this task.
There is a missing a DLL file, which is needed by Windows Authentication.
Resolution
If the problem is related to the JTDS driver refer to this MSDN article.
If the error is due to a missing DLL file, complete the following:
Download the "ntlmauth.dll" file in from here.
Copy the DLL-file onto your PC in the directory
C:\Windows\system32.Restart SQL server.
Restart JIRA.
Was this helpful?