Microsoft KB Archive/885999

= &quot;Setup has encountered fatal errors during database initialization&quot; error message when you try to reinstall Systems Management Server 2003 =

Article ID: 885999

Article Last Modified on 10/27/2006

-

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

Registered the types

SqlExecute 

CSql::Execute failed, SQL error <[42000][15401][Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group ' \SMS_SiteSystemToSQLConnection_ ' 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  \SMS_SiteSystemToSQLConnection_  group, and then click Delete.

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

Note  is the name of the new domain controller.
 * 1) Close SQL Server Enterprise Manager.
 * 2) 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 &quot;Applies to&quot; section.

Keywords: kbsmsuninstall kbsmssecurity kbsmsinstall kbsms2003bug kbtshoot kbbug kberrmsg kbsetup kbinterop kbsecurity KB885999

-

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

© Microsoft Corporation. All rights reserved.