WebSphere Application Server & Liberty

I’m currently trying to get the V9 mapper node to connect to Microsoft SQL Server  using Integrated Authentication through the JDBC provider configurable service on a Windows Server 2008 Integration Node.

The error that is being returned is that the driver is not setup for authentication even though I have the sqljdbc_auth.dll (32bit) specified on the IBM_JAVA_OPTIONS=-Djava.library.path=c:\temp\sqljdbc_auth.dll and have tried dropping it in several places in the JVM path and the Windows path.

It works fine if I follow the directions explicitly from IBM using a SQL Server login, but that is not allowed here, so working outside the box. Here is a sample connectionUrlFormat string -

jdbc:sqlserver://[serverName]\[connectionUrlFormatAttr1]:[portNumber];database=[databaseName];integratedSecurity=true;
connectionUrlFormatAttr1 is holding the SQL Server Instance name.

Have made some progress on this with IBM's help. Was finally able to get my local machine to connect when I dropped the sqljdbc_auth.dll in the SysWoW64 folder. I'm attempting to duplicate the success on the actual server and back to the same error, so having to double check that everything got configured correctly. The server application id that runs IIB is in the SQL Server role group, so that shouldn't be an issue.