Setting up the Spotfire Server bootstrap file for Integrated Windows authentication

To configure Integrated Windows authentication (IWA) between Spotfire Server and the Spotfire database in SQL, follow these steps.

Procedure

  1. Check that the sqljdbc4.jar file with Microsoft's vendor JDBC drivers is in the following Spotfire Server folder: <installation dir>\tomcat\lib.
  2. Copy the sqljdbc_auth.dll file from the <installation dir>\tomcat\bin folder to the c:\windows\SysWOW64 folder.
  3. Change the login for the service to use the Windows account that has login rights to the Spotfire database.
  4. In the bootstrap command, use the following database connection string, substituting actual values for <db_server>, <port>, and <instance>:
    jdbc:sqlserver://<db_server>:<port>;DatabaseName=<instance>;integratedSecurity=true