Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 918711 - Last Review: October 27, 2006 - Revision: 2.1
Error message when you try to install the Availability Reporting Management Pack for Microsoft Operations Manager 2005 Service Pack 1: "Error: -2147217900: failed to execute SQL string"
When you try to install the Availability Reporting Management Pack for Microsoft Operations Manager (MOM) 2005 Service Pack 1 (SP1) , you receive the following error message:
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 compatibility level for the current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using...
This problem occurs because the Microsoft SQL Server 2005 stored procedures that are used during the following operations are not strictly compliant with American National Standards Institute (ANSI) standard:
- Installation of the Availability Reporting Management Pack
- The Windows AvailabilityAnalysisReporting task
Strict ANSI compliance is enforced in SQL Server 2005 databases.
To work around this problem, change the database compatibility level of the SystemCenterReporting database from SQL Server 2005 (Level 90) to Microsoft SQL Server 2000 (Level 80).
Note You must change the database compatibility level before you install the Availability Reporting Management Pack.
To change the compatibility level of the SystemCenterReporting database, follow these steps:
- Open SQL Server Management Studio, and then connect to the MOM Reporting database server.
- In Object Explorer, expand the MOM Reporting database server, expand Databases, and then Expand System Databases.
- Right-click the SystemCenterReporting database, and then click New Query.
- In the query window, type sp_dbcmptlevel 'SystemCenterReporting',80, and then press CTRL+E to run the query.
If the query ran successfully, you should receive the following message:
executed DBCC execution completed
Note If you receive DBCC Error message Text, contact the system administrator.
- Install the Availability Reporting Management Pack.
This problem is resolved in version 05.0.5000.0000 of the Availability Reporting Management Pack. To obtain this version, visit the following Microsoft Web site:
If you install the Availability Reporting Management Pack for MOM 2005 SP1 on a computer that has SQL Server 2000 installed, and then upgrade to Microsoft SQL Server 2005, you should not have to change the compatibility level of the SystemCenterReporting database. However, if the Windows AvailabilityAnalysisReporting task is failing to run and reports a
Last Result status of 0x80040e14 after the upgrade, the compatibility level of the SystemCenterReporting database may have been upgraded to level 90. You can examine the compatibility level by using the
sp_dbcmptlevel stored procedure. For example, the
sp_dbcmptlevel 'SystemCenterReporting' procedure displays the compatibility level.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005 Service Pack 1, when used with:
- Microsoft SQL Server 2005 Reporting Services
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate