You receive a "Setup cannot upgrade the SMS database contact SQL administrator" error message when you try to install Systems Management Server 2.0 SP4 (883985)


The information in this article applies to:

  • Microsoft Systems Management Server 2.0 SP3

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.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbtshoot kbDatabase kberrmsg kbUpgrade kbSysSettings kbsetup kbinterop KB883985 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.