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
-
Check that the
sqljdbc4.jar file with Microsoft's vendor JDBC drivers is in the following
Spotfire Server folder:
<installation dir>\tomcat\lib.
-
Copy the
sqljdbc_auth.dll file from the
<installation dir>\tomcat\bin folder to the
c:\windows\SysWOW64 folder.
-
Change the login for the service to use the Windows account that has login rights to the
Spotfire database.
-
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
Copyright © TIBCO Software Inc. All rights reserved.