Installing JIRA with SQL Server 2005 Fails due to 'Native SSPI Library not Loaded' Error
Unable to render {include} The included page could not be found.
Symptoms
JIRA running with SQL Server 2005 fails to start up, throwing the following error in the logs:
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.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.