SMS: An Error Was Reported While Executing the Database Upgrade

• Microsoft Systems Management Server version 1.2

SYMPTOMS

When you run Setup.exe and attempt to apply Service Pack 2 (SP2) or Service Pack 3 (SP3) to a Microsoft Systems Management Server version 1.2 Site Server, an error occurs and you receive the following error message:

   An error was reported while executing the database upgrade script
   UPGRD12.SQL. The error was reported on line 180. Continue with setup?
   Press Okay to skip the upgrade script or Press Cancel to cancel setup.

CAUSE

Line number 180 in the Upgrd12.sql script runs the Dbcnv12a.exe program to convert tables in the Systems Management Server database through the SqlExec function. This function may not work in some SQL environments that use integrated security.

WORKAROUND

Make the following two changes to the Upgrd12.sql script.

• Replace line number 180 ("sqlexec dbcnv12a") with

        EXEC master..xp_cmdshell "C:\SMS\SITE.SRV\X86.BIN\dbcnv12a.exe"
  

• Replace the last line ("sqlexec dbcnv12") with

        EXEC master..xp_cmdshell "C:\SMS\SITE.SRV\X86.BIN\dbcnv12.exe"
  

Copy Systems Management Server SP3 to the system's hard disk, copy the new Upgrd12.sql script to this source, and then run the SP3 Setup.exe program again.

Verify that the Dbcnv12a.exe and Dbcnv12.exe which are mentioned in the modified script's path, actually exist in the directory specified.