...
| 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. Tomcat must be able to find the sqljdbc_auth.dll file. This is supplied with PhixFlow, in <PHIXFLOW WEBAPP>\WEB-INF\lib64. Set the java option Java option -Djava.library.path in the Tomcat configuration to tell Java Tomcat the location of the sqljdbc_auth.dll file:directory that contains this file. E.g.
-Djava.library.path=C:\app\Tomcat70tomcat90\webapps\phixflow\WEB-INF\liblib64
ii2. Update the url property in the phixflow-datasource.xml file to contain the following SQLServer DB connection url :-
...
by adding the argument integratedSecurity=true. E.g.:
| Code Block |
|---|
<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> --> |
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.2. If
UnsatisfiedLinkError
If you get the following exception:
...