Microsoft KB Archive/142039

= Restrictions on Making SQL Server Changes for a Child Site =

Article ID: 142039

Article Last Modified on 6/14/2005

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q142039





SYMPTOMS
Running SMSSetup at a central site does not allow you to change the reporting of a child site from one SQL server to another or to change the SQL password for a child site.



CAUSE
SMSSetup is run directly from a site server and is used to make changes for that site only. SMSSetup allows you to make changes to the SQL Server, such as the server name, database, logon ID, and password. These changes are changed for the current site only. If you change the name of the SQL Server, this means that the current site, from which you are running SMSSetup, will report to the new server. Currently there is no way to focus on a child site and run SMSSetup to change the SQL Server information for that child site.

The SMS Administrator's Manual and online Help indicate that changes made are for the current site, but in fact you cannot use the SMSSetup to make changes for a child site.



RESOLUTION
In order to make changes for a child site, SMSSetup must be run from the site server for the child site.



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 1.x. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: KB142039

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.