Microsoft KB Archive/137988

= "Final SQL Operations Failure" Error when Upgrading to SMS 1.1 =

Article ID: 137988

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.1 Standard Edition

-



This article was previously published under Q137988



SYMPTOMS
When you attempt to upgrade Systems Management Server from version 1.0 to version 1.1, the following error message appears:

Final SQL Operations failure



CAUSE
You may find the cause of this error in the bottom section of the C:\SMSSETUP.LOG file. Frequently, the file contains the cause of the failed SQL operations, or the cause may be in the SQL registry key: SMSVersion.



RESOLUTION
To correct this problem, modify the registry:

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

 Run Registry Editor (REGEDT32.EXE).  From the HKEY_LOCAL_MACHINE subtree, go to the following key: \SOFTWARE\Microsoft\SMS\Setup  Select Version. From the Edit menu, choose String. If the value is 692, change the value to 600. Choose OK and quit the Registry Editor.</li> Shut down and restart Windows NT.</li> Run the upgrade program again to upgrade to Systems Management Server 1.1.</li></ol>

Additional query words: prodsms sms

Keywords: kbnetwork kbsetup KB137988

-

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

© Microsoft Corporation. All rights reserved.