Microsoft SQL Server database missing when creating a connection via Microsoft SQL Server Data Connector or Information Designer due to compatibility error
Article ID: KB0082886
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
When attempting to connect to a Microsoft SQL Server database via Microsoft SQL Server Data Connector or Information Services in the TIBCO Spotfire Installed client, the desired database is not visible in the list. For example, when attempting to connect via a data connection, if you enable DEBUG logging on the TIBCO Spotfire Installed client (Help > Support Diagnostics and Logging > Logging tab > Log level: Debug) and attempt to connect to the database, you may see a log entry similar to:
2017-08-25T11:17:58,686-04:00 2017-08-25 15:17:58,686 user [53] DEBUG Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection [(null)] - ConnectAndGetDatabaseNames: Database "SQLDB" has compatibility level 80. Skipping.
Issue/Introduction
The desired database is missing when trying to connect to a Microsoft SQL Server database via the Microsoft SQL Server Data Connector or Information Designer
Resolution
That message is referring to the compatibility of the database as defined on the Microsoft SQL Server. In this example, "Database "SQLDB" has compatibility level 80" means that the SQL Server compatibility mode on the database is set to "SQL Server 2000".
To resolve the issue, change the compatibility level of the database to a higher and supported version so that the databases will be present in the list. For example, switching to 100 would correspond with the supported "SQL Server 2008".
To resolve the issue, change the compatibility level of the database to a higher and supported version so that the databases will be present in the list. For example, switching to 100 would correspond with the supported "SQL Server 2008".
Additional Information
External: View or Change the Compatibility Level of a Database
Feedback
Yes
No
Powered by
