We're using the application server based data source configuration to connect to a SQL Server 2008 R2 database using a jtds driver. The database is currently set to mixed mode authentication and we have been using sql server authentication (user name and password) without any issue. We now have a requirement to use Windows Authentication Mode (SSO) only to authenticate to the database. This requires the use of a dll, ntlmauth.dll which must be located somewhere in the path. We have this configured and working for Confluence, but the Bob Swift SQL Pro Plugin, which is using the same data source as Confluence (configured for Windows Authentication), no longer works. We get the following error:
Error rendering macro 'sql' : 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.)
We know the driver is configured correctly since Confluence itself is now authenticating using Windows Authentication. No changes have been made to the plugin configuration, it still points to the working Confluence data source. The dll is specified on the java.library.path and we've also tried putting the dll in other locations like system32 and the java bin directory. No matter where we put the dll the plugin always throws the same error, but Confluence itself authenticates successfully.
Does anyone have experience with getting this configuration to work?
I work with Carl and I was able to resolve the problem.
Confluence was configured to use the default hibernate cfg.xml datasource. We additionally configured a server.xml JNDI resource for use by the SQL plugin.
It seems like it was a timing / class loading issue as like Carl stated, Confluence would authenticate just fine. We would only get the error once the JNDI resource was referenced by the SQL plugin on page load.
I changed the hibernate configuration to reference a new JNDI resource (separate from the one being used by the SQL plugin), and it repaired the issue.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs