Creating a bootstrap file from Spotfire Server Configuration UI when using Windows Authentication for Microsoft SQL Server.
Article ID: KB0083651
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.10 and lower |
Description
Description:
When using Windows Authentication, the credentials from the Windows User which launched the configuration UI will be used when connecting to the Spotfire Server Database. When running the Spotfire Server, the credentials from the user running the Spotfire Server Service will be used when connecting to the Spotfire Server Database. The username and password manually entered (if any) in the configuration will not be used when using Windows Authentication. Username and password is only used when using Microsoft SQL Server basic authentication.
When using Windows Authentication, the credentials from the Windows User which launched the configuration UI will be used when connecting to the Spotfire Server Database. When running the Spotfire Server, the credentials from the user running the Spotfire Server Service will be used when connecting to the Spotfire Server Database. The username and password manually entered (if any) in the configuration will not be used when using Windows Authentication. Username and password is only used when using Microsoft SQL Server basic authentication.
Issue/Introduction
Creating a bootstrap file from Spotfire Server Configuration UI when using Windows Authentication for Microsoft SQL Server.
Resolution
1). Make sure that you are running the configuration UI with the same username that you entered for the WINDOWS_LOGIN_ACCOUNT in the ‘scripts\mssql_install\create_databases_ia.bat’ file (bundled with Spotfire Server Installation) at the time when running the bat file. In case you want to use another account, you must make sure that the other account has login permission for the Microsoft SQL Server and has been granted control rights for the Spotfire Server Database.
To run the configuration UI with a specific user account, either login with that account in Windows or right-click the ‘Configure TIBCO Spotfire Server’ shortcut in the start-menu and choose ‘Run as different user’.
2). The TIBCO Spotfire Server Configuration Tool should now be started. Click on the first link, ‘Create new bootstrap file...’ located under ‘Connect to Database’.
3). Set ‘Database server:’ to ‘Microsoft SQL Server’.
Set ‘JDBC driver’ to ‘Microsoft’.
Set ‘Hostname:’ to the hostname of the server where you are running Microsoft SQL Server which is hosting the Spotfire Server Database.
Set ‘Database name’ to the name you've entered for SERVERDB_NAME in the ‘scripts\mssql_install\create_databases_ia.bat’ at the time when you run that bat file.
Optional: Set ‘Encryption password’ and ‘Confirm encryption password’.
4). Add ‘;integratedSecurity=true’ to the Database URL. This is needed in order to tell the Microsoft JDBC driver to use the current Windows account credentials for authentication.
Example:
jdbc:sqlserver://example.com:1433;DatabaseName=spotfire_server;integratedSecurity=true
5). Click ‘Create Bootstrap’.
Note: Spotfire Server will now use the current Windows account credentials for authentication to the Spotfire Server Database. This means that the credentials from the user who’s starting the service will be used when connecting to the Spotfire Server Database. It is recommended that you also set the ‘Log On’ for Spotfire Server in ‘Windows Services’ to the Spotfire Server Database Account.
Feedback
Yes
No
Powered by
