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


The information in this article 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 <if not exists (select * from sysusers
where name = "DomainName\SMS_SiteSystemToSQLConnection_SiteCode") exec sp_grantdbaccess "DomainName\SMS_SiteSystemToSQLConnection_SiteCode"> <07-06-2004 14:53:13> CSql::Execute failed, SQL error
<[42000][15024][Microsoft][ODBC SQL Server Driver][SQL Server]The group 'DomainName\SMS_SiteSystemToSQLConnection_SiteCode' already exists in the current database. : sp_grantdbaccess
DomainName is the name of the domain, and SiteCode 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_SiteCode 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 DomainName\SMS_SiteSystemToSQLConnection_SiteCode to SMS_SiteSystemToSQLConnection_SiteCode. In this case, when you try to upgrade the SMS 2003 site server, the Setup program cannot find the DomainName\SMS_SiteSystemToSQLConnection_SiteCode 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_SiteCode account from the SMS database on the SQL Server, and then add the correct domain account. To do this, follow these steps:
  1. Use an account that has domain administrator permissions to log on to the SMS site server.
  2. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  3. In the SQL Enterprise Manager snap-in, expand Microsoft SQL Servers, expand SQL Server Group, expand ServerName, expand Databases, expand SMS_SiteCode, and then click Users.
  4. In the Details pane, right-click SMS_SiteSystemToSQLConnection_SiteCode, and then click Delete.
  5. Right-click Users, and then click New Database User.
  6. In the New User dialog box, use the DomainName\UserName syntax to type the name of the SMS SQL Server connection account. For example, type:

    DomainName\SMS_SiteSystemToSQLConnection_SiteCode

  7. Click OK.

STATUS

This behavior is by design.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbtshoot kbprb KB886151 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.