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

Article translations Article translations
Article ID: 229875 - View products that this article applies to.
This article was previously published under Q229875
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 52146 (SQLBUG_70)
Expand all | Collapse all

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 hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language. 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.

Properties

Article ID: 229875 - Last Review: November 3, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbautohotfix kbhotfixserver kbbug kbfix kbqfe KB229875

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com