Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 889434 - Last Review: October 27, 2006 - Revision: 1.3
You cannot use Remote.exe to connect to a Systems Management Server 2.0 client computer after running the Conv20.exe utility
After you run the Conv20.exe utility on a Microsoft Systems Management Server (SMS) 2.0 site server to test the integrity of the SMS database, when you try to use Remote.exe from the command line to connect to an SMS client, you may receive the following error message:
Additionally, the Smsprov.log file in the /SMS/Logs folder on the SMS site server may contain the following error message:
Error Extracting property:TopLevelSiteCode
SQL Error: Could not find stored procedure 'sp_GetRights'
This problem typically occurs after you run the Conv20.exe utility on an SMS site server. The Conv20.exe utility may remove the sp_GetRights stored procedure from the SMS database.
To resolve this problem, use Remote Tools in the SMS Administrator console to connect to the SMS client. To do this, follow these steps:
- Click Start, point to Programs, point to Systems Management Server, and then click SMS Administrator Console.
- In the SMS Administrator console, expand Site Database (SiteCode-SiteName), expand Collections, and then click All Systems.
- In the details pane, right-click the SMS client computer, click All Tasks, and then click Start Remote Tools.
This re-creates the sp_GetRights stored procedure.
Note The sp_GetRights stored procedure is not re-created when you try to run Remote.exe from the command line.
You can now use Remote.exe from the command line to connect to the SMS client.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For additional information about the Conv20.exe tool, click the following article number to view the article in the Microsoft Knowledge Base:
200653Â
(http://kbalertz.com/Feedback.aspx?kbNumber=200653/
)
SMS: Using Conv20.exe to check database integrity
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please