...
| Info |
|---|
To configure integrated authentication for a 32-bit JVM, please contact PhixFlow Support. |
Configuration
The following steps are required to enable server support for Integrated Authentication when using a 64-bit Java JVM.
i1. 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
ii2. Update the phixflow-datasource.xml file to contain the following SQLServer DB connection url :-
...
</property>
<!—The username and password are no longer needed -->
<!-- <property name="username"><value>train</value></property> -->
<!-- <property name="password"><value>train</value></property> -->
iii3. Start up Tomcat and log into PhixFlow as normal.
Trouble-shooting
...
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:
...
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
2. If If you get the following exception:
...