FIX: Unable to Perform Automated Installation of SQL 7.0 Using File Images (229875)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q229875
BUG #: 52146 (SQLBUG_70)

SYMPTOMS

During a mass rollout of Windows NT Server or Workstation, you may elect to install SQL Server 7.0 using image files. This streamlines the installation process by automating and standardizing across all company servers. A problem with this type of installation can occur because of a conflict with the Windows NT Server name and the following registry entry: 
   HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\checksum
During startup, SQL Server reads this registry value and compares it to the Windows NT Server name. If a conflict occurs, the server startup is stopped and the following error message appears:
Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please rerun Setup.
You have no option but to acknowledge this dialog box by clicking the OK button.

To correct this problem, you must rerun SQL Server 7.0 setup from the original installation CD and perform an upgrade, essentially overwriting the registry with the correct server name. However, running an unattended upgrade is not supported in the retail build of SQL Server 7.0, thereby prohibiting a fully automated installation using image files.

CAUSE

Unattended upgrade was originally not allowed in the retail build of SQL Server 7.0 to help prevent piracy.

RESOLUTION

A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem. This fix may receive additional testing. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next SQL Server service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later: 
   Date      Time    Version      Size    File name   Platform
   -----------------------------------------------------------

   04/06/99  2:32PM  7.00.657     216KB   Setup.ins   Intel
   04/06/99  2:32PM  7.00.657     216KB   Setup.ins   Alpha
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.

WORKAROUND

On each computer, rerun SQL Server 7.0 setup from the original installation CD and perform an attended upgrade.

STATUS

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

MORE INFORMATION

Following are the steps required to automate the installation of SQL Server 7.0 using an image installation utility. Note that all steps must be performed. It is assumed that the utility has some scripting capabilities that enables it to run SQL Server 7.0 setup in an unattended mode.

The SQL Server 7.0 image files must be created using a setup server, called "ServerA" in the following steps. The image files need to be copied to a destination server, called "ServerB".
  1. Install SQL Server 7.0 on ServerA by running setup from the SQL Server 7.0 CD. Verify that the installation was successful.
  2. Change the Windows NT Server name on ServerA. Verify that SQL Server will not start.
  3. On ServerA, run SQL Server 7.0 Setup from the CD and perform an upgrade. This creates a Setup.iss file, which will be used during the unattended setup performed in these steps. Note that this Setup.iss file will be created in the MSSQL7\Install directory. Verify that SQL Server will start.
  4. Create the file images on ServerA and then copy them to ServerB using the imaging utility.
  5. When installing SQL Server 7.0 Standard edition on Windows NT Server 4.0, copy the following files from the SQL Server 7.0 CD to a temporary directory on ServerB:

    \Binn\Regrebld.exe
    \Binn\Setupex.dll
    \Binn\Sqlboot.dll
    \Binn\Sqlsusk.dll
    \Setup\Layout.bin
    \Setup\Os.dat
    \Setup\Setup.ini
    \Setup\Setup.lid
    \Setup\Setupsql.exe
    \Setup\Sqlstp.exe
    \Setup\_isdel.exe
    \Setup\_setup.dll
    \Setup\_sys1.cab
    \Setup\_user1.cab

    Intel-specific instructions:

    Copy the \Setup\_inst32i.ex_ file to the same directory.

    NOTE: Files should be copied from subdirectories under the X86 directory on the CD. For example, copy the X86\Binn\Regrebld.exe file to ServerB_temp_directory\X86\Binn\Regrebld.exe.

    Alpha-specific instructions:

    Copy the file \Setup\_inst32a.ex_ to the same directory.

    NOTE: Files should be copied from subdirectories under the Alpha directory on the CD. For example, copy the Alpha\Binn\Regrebld.exe file to ServerB_temp_directory\Alpha\Binn\Regrebld.exe.

    IMPORTANT: When installing any other edition/platform combination, copy all files from the appropriate directory (X86 or Alpha) on the SQL Server 7.0 CD to a temporary directory on ServerB.
  6. Copy the Setup.ins file from the hotfix to ServerB's temporary \Setup directory.
  7. If you are installing the SQL Server 7.0 Desktop Edition, run the following command to start unattended setup on ServerB: 
    start  /wait D:\sphinx\x86\setup\SETUPSQL.EXE k=Dk -f1 C:\MSSQ7\Install\setup.iss -SMS -s
    SETUPSQL.exe defaults to installing the standard edition. The k=Dk switch specifies to install the Desktop Edition.
  8. Verify that SQL Server starts on ServerB.
Modification Type:MinorLast Reviewed:10/5/2005
Keywords:kbbug kbfix kbQFE KB229875
©2004 Microsoft Corporation. All rights reserved.