BUG: 7.0 Upgrade Loops When 6.5 Parameters Are Reversed

ID: Q231988

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 53719 (SQLBUG_70)
BUG #: 56974 (SQLBUG_70)

SYMPTOMS

When attempting to upgrade SQL Server version 6.5 to SQL Server version 7.0, the wizard continually reverts back to the Logon screen with no error message. The upgrade wizard allows the user to advance to either the Logon or Code page screen, but continually fails back to the Logon screen once you click Next.

This problem occurs when the Startup Parameters for SQL Server 6.5 have been modified from their original configuration. This can be seen under the following:

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\PARAMETERS

SQLArg0 points to the error log and SQLArg1 points to Master.dat Or, in the server configuration under Parameters, the master is listed under the error log parameter. For example:


   -e<drive>:<directory>\ERRORLOG
   -d<drive>:<directory>\MASTER.DAT

WORKAROUND

Modify parameters in Enterprise Manager/Parameters so that master is above the error log. For example:


   -d<drive>:<directory>\MASTER.DAT
   -e<drive>:<directory>\ERRORLOG

Or modify the Parameters key under the following so that SQLArg0 is pointing to Master.dat and SQLArg1 is pointing to the error log:

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\PARAMETERS

Another situation in which this problem may occur would be if the master.dat file is stored on the root drive.

For example:

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\PARAMETERS SQLArg0 -dD:\MASTER.DA

The user should modify the parameters so that Master.dat is placed inside a directory, and not on the root drive. For example:


SQLArg0     -dd:\MSSQL\DATA\MASTER.DAT
SQLArg1     -ec:\MSSQL\LOG\ERRORLOG

The master.dat file MUST be in a directory other than a root and without a space in the path.

To work around this situation use the following steps:

If SQL 6.5 is installed on the same computer, remove the SQL Server 7.0 installation.

Follow the steps described in this Microsoft Knowledge Base article:

Q181602 INF: How to Move a Device to Another Location

Install SQL Server 7.0.

Use the Upgrade Wizard.

Another approach to workaround the problem is to dump the databases, uninstall SQL Server 6.5, then reinstall SQL Server 6.5 with the Master.dat file being written to a directory rather than to the root drive. Then, restore the SQL Server 6.5 databases, install SQL Server 7.0, and then run the Upgrade Wizard.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: Upgrade hang

Keywords :
Version : winnt:7.0
Platform : winnt
Issue type : kbbug