KB918711 - "Error: -2147217900: failed to execute SQL string" when installing Microsoft Operations Manager 2005 Service Pack 1 Availability Reporting Management Pack

  • Article

Pending release at this time

My favourite subject ;)

Summary

Attempting to install the Availability Reporting Management Pack against a new SystemCenterReporting database on SQL Server 2005 gives the error

"Error: -2147217900: failed to execute SQL string, error detail: The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibiility level for the current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using... "

Cause: SQL Server 2005 strictly enforces ANSI SQL compliance on newly created databases. The Availability Reporting MP uses several stored procedures during both installation and general operation which are not fully ANSI SQL compliant.

Workaround: For new installs of SQL Server 2005 change the database compatibility level to SQL 2000 on the SystemCenterReporting database e.g.  sp_dbcmptlevel 'SystemCenterReporting',80

SQL Server 2000 to SQL Server 2005 upgrades DO NOT need this workaround as the database compatibility level is maintained at SQL Server 2000. Do not upgrade the compatibility level to 90 on the SystemCenterReporting database.

The fully documented article https://support.microsoft.com/?id=918711 should be published shortly. Please use this article for complete information.