Microsoft KB Archive/886151

= You cannot upgrade a Systems Management Server 2003 site server after the site server has been moved to a different domain =

Article ID: 886151

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
When you try to upgrade your Systems Management Server (SMS) 2003 site server from SMS 2003 to SMS 2003 Service Pack 1 (SP1), the upgrade process may fail, and you may receive an error message that is similar to the following in the SMSSetup.log file:

<07-06-2004 14:53:13> SqlExecute  <07-06-2004 14:53:13> CSql::Execute failed, SQL error

<[42000][15024][Microsoft][ODBC SQL Server Driver][SQL Server]The group ' \SMS_SiteSystemToSQLConnection_ ' already exists in the current database. : sp_grantdbaccess

is the name of the domain, and  is the three-letter SMS 2003 site code. The SMSSetup.log file is located in the root directory of the SMS 2003 site server.



CAUSE
This behavior typically occurs when you move the SMS site server to a different domain. In this scenario, the original domain name prefix that is appended to the SMS_SiteSystemToSQLConnection_ Microsoft SQL Server connection account may be removed.

For example, when you move an SMS site server to a different domain, the SQL Server connection account that is used to connect to the SMS database may be changed from \SMS_SiteSystemToSQLConnection_  to SMS_SiteSystemToSQLConnection_. In this case, when you try to upgrade the SMS 2003 site server, the Setup program cannot find the \SMS_SiteSystemToSQLConnection_  account, and the upgrade process fails.

Note You cannot move the SMS site server to a different domain in SMS 2003. Moving an SMS 2003 site server to a different domain is currently not supported.



WORKAROUND
To work around this problem, delete the SMS_SiteSystemToSQLConnection_ account from the SMS database on the SQL Server, and then add the correct domain account. To do this, follow these steps:  Use an account that has domain administrator permissions to log on to the SMS site server. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager. In the SQL Enterprise Manager snap-in, expand Microsoft SQL Servers, expand SQL Server Group, expand, expand Databases, expand SMS_ , and then click Users. In the Details pane, right-click SMS_SiteSystemToSQLConnection_ , and then click Delete. Right-click Users, and then click New Database User. In the New User dialog box, use the \  syntax to type the name of the SMS SQL Server connection account. For example, type:

\SMS_SiteSystemToSQLConnection_

</li> Click OK.</li></ol>

<div class="status_section">

STATUS
This behavior is by design.

Additional query words: SMS connection account

Keywords: kbtshoot kbprb KB886151

-

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

© Microsoft Corporation. All rights reserved.