Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...