Product: TIBCO Spotfire®
Microsoft SQL Server database missing when creating a connection via Microsoft SQL Server Data Connector or Information Designer due to compatibility error
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  DEBUG Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection [(null)] - ConnectAndGetDatabaseNames: Database "SQLDB" has compatibility level 80. Skipping.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".
External: View or Change the Compatibility Level of a Database