"Setup has encountered fatal errors during database initialization" error message when you try to reinstall Systems Management Server 2003 (885999)


The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

When you try to reinstall Microsoft Systems Management Server (SMS) 2003, you receive the following error message:
Systems Management Server Setup cannot continue because of the following error:

Setup has encountered fatal errors during database initialization. Contact your SQL administrator.
This problem occurs when the Setup program tries to access the instance of Microsoft SQL Server. When this problem occurs, the following message is logged in the Smssetup.log file: SQL user connections are set to auto grow, no need to reset it.
SQL memory is at least 16 meg, no need to reset it.
SQL open objects are set to auto grow, no need to reset it.
SQL locks are set to auto grow, no need to reset it.
SQL Checkpoint 5
Entering FinalSqlOperations
Registering connects for SMS SiteCode
Registered the types
SqlExecute <sp_grantlogin "Domain\SMS_SiteSystemToSQLConnection_SiteCode">
CSql::Execute failed, SQL error <[42000][15401][Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'Computer\SMS_SiteSystemToSQLConnection_SiteCode' not found. Check the name again. : sp_grantlogin

CAUSE

This problem may occur if the following conditions are true and if they occur in this order:
  1. You remove an SMS 2003 site server on a domain member server.
  2. You promote the domain member server to a domain controller.
  3. You then try to reinstall the SMS 2003 site on the new domain controller.
When you remove an SMS 2003 site, the Setup program does not remove the SQL logins for the earlier installation.

WORKAROUND

To work around this problem, delete the existing SQL security groups, and then run the Setup program again. To do this, follow these steps:
  1. Start SQL Server Enterprise Manager.
  2. Expand Microsoft SQL Servers\SQL Server Group\(local)(Windows NT)\Security, and then click Logins.
  3. Right-click the Computer\SMS_SiteSystemToSQLConnection_SiteCode group, and then click Delete.

    Note SiteCode is the site that you removed, and Computer is the name of the new domain controller.
  4. Right-click the Computer\SMS Admins group, and then click Delete.

    Note Computer is the name of the new domain controller.
  5. Close SQL Server Enterprise Manager.
  6. Run the SMS 2003 Setup program again.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:7/8/2005
Keywords:kbSMSUninstall kbSMSSecurity kbSMSInstall kbSMS2003bug kbtshoot kbBug kberrmsg kbsetup kbinterop kbSecurity KB885999 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.