MS SQL Server Integrated Authentication

Configuration

The following steps are required to enable server support for Integrated Authentication when using a 64-bit Java JVM.

1. Set the java option in the Tomcat configuration to tell Java the location of the sqljdbc_auth.dll file:

 -Djava.library.path=C:\Tomcat70\webapps\phixflow\WEB-INF\lib

2. Update the phixflow-datasource.xml file to contain the following SQLServer DB connection url :-

<property name="driverClassName">

<value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>

</property>
<property name="url">

<value>jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=train;integratedSecurity=true</value>

</property>
<!—The username and password are no longer needed -->
<!-- <property name="username"><value>train</value></property> -->
<!-- <property name="password"><value>train</value></property> -->

3. Start up Tomcat and log into PhixFlow as normal.

Troubleshooting

This driver not configured for integrated authentication

 On a Windows platform, when trying to connect to SQL Server using Integrated Authentication, you may see this exception:

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
along with the following trace message:
com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll

This typically indicates that the driver cannot find the appropriate sqljdbc_auth.dll in the JVM library path. To correct the problem, please make sure the java option -Djava.library.path is set to the full path of the DLL file.
Note: You may also get the same error message if the application is trying to use the incorrect architecture (x86 VS x64) version of the sqljdbc_auth.dll.

UnsatisfiedLinkError

 If you get the following exception:

java.lang.UnsatisfiedLinkError: GetDNSName

This typically indicates that the application is trying to use the incorrect version (say v1.0 VS v1.1) of the sqljdbc_auth.dll. Make sure the application is using the save version of the sqljdbc.jar and sqljdbc_auth.dll files.