Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 923109 - Last Review: February 8, 2007 - Revision: 1.2
Remote reporting points, management points, and server locator points no longer function after you upgrade to Systems Management Server 2003 Service Pack 2
After you upgrade the Microsoft Systems Management Server (SMS) 2003 site server to SMS 2003 Service Pack 2 (SP2), remote reporting points, management points, and server locator points no longer function.
When you run a report, you receive the following error message in Microsoft Internet Explorer. This error message indicates that a problem exists with the SMS reporting point:
Number=-2147467259 Description=[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Source=Microsoft OLE DB Provider for SQL Server NativeError=17
The following error message is logged in the MP_GetAuth.log file. This error message indicates that a problem exists with the management point:
CMPDBConnection::Init(): IDBInitialize::Initialize() failed with 0x80004005
This behavior only occurs if you change the site security from standard security to advanced security when you upgrade to SMS 2003 SP2.
This problem occurs because SMS 2003 is still trying to use the SMS_SQL_RX_
site code account from standard security to access the SMS database. Instead, SMS 2003 should use the local system account.
To work around this problem, contact Microsoft Product Support Services.
For a list of Microsoft Product Support Services telephone numbers, visit the following Microsoft Web site:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Systems Management Server 2003 Service Pack 2
| kbtshoot kbsmsmp kbsmsslp kbprb kbsmsreporting kbsmssecurity KB923109 |
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