Microsoft KB Archive/883985

= You receive a &quot;Setup cannot upgrade the SMS database contact SQL administrator&quot; error message when you try to install Systems Management Server 2.0 SP4 =

Article ID: 883985

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Service Pack 3

-





SYMPTOMS
You receive the following error message when you try to install Microsoft Systems Management Server (SMS) 2.0 Service Pack 4 (SP4):

Fatal Error

Systems Management Server setup cannot continue because of the following error.

Setup cannot upgrade the SMS database contact SQL administrator.

The following text is logged in the SMSSetup.log file: SqlExecuteAsync < Delete From StatusMessageInsStrs Where RecordID Not in(Select RecordID from StatusMessages)> Cannot execute sql command Delete From StatusMessageInsStrs Where RecordID Not in(Select RecordID from StatusMessages) The following text is logged in the Microsoft SQL Server error log: Server has run out of locs Rerun your statement when there are fewer active users or ask the administrator to reconfigure SQL Server with more locks



CAUSE
This issue may occur if the database locks that are in Microsoft SQL Server are configured as static. To confirm that this is the cause of the issue, follow these steps:
 * 1) Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
 * 2) Type SP_configure locks.
 * 3) On the Query menu, click Execute.

If the locks are configured as dynamic, the run value is 0 (zero). If the run value is not 0, the locks are configured as static.



RESOLUTION
To resolve this problem, reconfigure the locks as dynamic. To do this, follow these steps.

Warning If you manually modify the SMS database, you may cause serious problems. These problems may require that you reinstall SMS or Microsoft SQL Server. We cannot guarantee that you can solve problems that may result if you modify the database incorrectly. Manually modify the database at your own risk. We recommend that you back up the complete site and the complete site database before you follow these steps.
 * 1) Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
 * 2) Type SP_configure 'locks',0, and then press ENTER to move to the next line.
 * 3) Type reconfigure with override.
 * 4) On the Query menu, click Execute.
 * 5) Run the SMS 2.0 SP4 Setup program again.

Keywords: kbtshoot kbdatabase kberrmsg kbupgrade kbsyssettings kbsetup kbinterop KB883985

-

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

© Microsoft Corporation. All rights reserved.