Invalid database connection string created by upgrade tool using previous configuration
Article ID: KB0077060
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 10.3 and higher |
Description
When upgrading to TIBCO Spotfire Server 10.3 or higher from a TIBCO Spotfire Server 10.2 or lower, connected to a Spotfire database on SQL Server using Integrated Authentication, the database connection string created by the upgrade tool when using "copy configuration from previous server configuration" may be invalid (missing a semicolon).
Attempting to proceed using this invalid connecting string results in the error "Invalid username/password".Issue/Introduction
Resolution
This is a known defect for TIBCO Spotfire Server 10.3 and higher.
To correct the issue, when running the upgrade tool, as the connection string is displayed in the Database Connection Information dialog, add the missing semicolon between the database name and the AuthenticationMethod.
Example:
Before (incorrect): jdbc:tibcosoftwareinc:sqlserver://myserver:1433;DatabaseName=mydatabaseAuthenticationMethod=ntlmjava
After (correct): jdbc:tibcosoftwareinc:sqlserver://myserver:1433;DatabaseName=mydatabase;AuthenticationMethod=ntlmjava
Feedback
