...
The following steps are required to enable server support for Integrated Authentication when using a 64-bit Java JVM.
1. Set the java option 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 -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:\Tomcat70app\tomcat90\webapps\phixflow\WEB-INF\liblib64
2. 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> --> |
3. Start up Tomcat and log into PhixFlow as normal.
...