How to Remotely Install MS SQL Server Version 7.0

  • Article

Updated : June 9, 2001

Stephen Dybing

Microsoft Corporation
December, 1998

Introduction

Microsoft SQL Server 7.0 is the latest version of the Microsoft SQL Server relational database product. This document explains how to use the SQL Server 7.0 Setup program to install the software on a remote computer.

The target audience for this document has a working knowledge of Microsoft® Windows NT® 4.0.

Before You Begin

For this remote installation process to work, the following conditions must be met:

  • Both of the computers must be running either Microsoft Windows NT Server 4.0 or Microsoft Windows NT Workstation 4.0.

  • Both of the computers must have the same processor type (either Intel or Alpha).

  • You must be logged on to the local computer with a user account that is an administrator on the remote computer.

For additional information about SQL Server Setup options, see Microsoft SQL Server Books Online and Microsoft SQL Server Setup book that is available in the software package.

After you have installed SQL Server on the remote computer, you can use SQL Server Enterprise Manager or SQL Server Service Manager to start and stop the remote SQL Server. For more information, see Microsoft SQL Server Setup.

Remotely Installing SQL Server 7.0

To remotely install Microsoft SQL Server 7.0, perform the following steps:

  1. Place the SQL Server 7.0 compact disc in the CD-ROM drive on the local computer running Windows NT 4.0.

  2. Click Install SQL Server 7.0 Components.

    Cc917535.70remot1(en-us,TechNet.10).gif

  3. Click Database Server – Standard Edition.

    Cc917535.70remot2(en-us,TechNet.10).gif

  4. In the Select Install Method dialog box, click Remote Install – Install to a Remote Machine, and then click Next.

    Cc917535.70remot3(en-us,TechNet.10).gif

  5. In the Remote Setup Information dialog box, type the username, password, and domain of the administrator account on the remote computer. Type the target machine name. Note that the Target Path (UNC) and Setup Source Files boxes are already populated. Click Next.

    Cc917535.70remot4(en-us,TechNet.10).gif

  6. When the Welcome dialog box appears, click Next.

    Cc917535.70remot5(en-us,TechNet.10).gif

  7. Read the license agreement and, if you agree, click Yes.

    Cc917535.70remot6(en-us,TechNet.10).gif

  8. Type your name and company name and then click Next.

    Cc917535.70remot7(en-us,TechNet.10).gif

  9. Type your CD key number and then click OK.

    70remot8

  10. In the next Setup dialog box, click OK.

    70remot9

  11. In the Setup Type dialog box, click Next.

    Cc917535.70remo10(en-us,TechNet.10).gif

  12. Type the service account name, password, and domain name of the account you want to use as the SQL Server service account, and then click Next.

    Cc917535.70remo11(en-us,TechNet.10).gif

  13. In the Setup Information dialog box, click Next.

    Cc917535.70remo12(en-us,TechNet.10).gif

  14. In the Setup Complete dialog box, click Finish.

    Cc917535.70remo13(en-us,TechNet.10).gif

  15. When the Setup dialog box appears, click OK.

    Cc917535.70remo14(en-us,TechNet.10).gif

  16. Click Exit.

    Cc917535.70remo15(en-us,TechNet.10).gif

  17. To complete the installation process, restart the remote computer.

SQL Server 7.0 Standard Edition is now installed on the remote computer and will start automatically when the computer is started. A new program group has been created on that remote computer; this new program group contains the SQL Server 7.0 utilities. However, if you want to administer that SQL Server remotely, install the SQL Server 7.0 Client Utilities on the computer you want to use for administration. Instructions are available in the "How to Install Microsoft SQL Server Version 7.0 Client Utilities" paper on TechNet.

If setup failed, you should examine the Windows_Root\Remsetup.log file on the local computer, and the Windows_Root\Sqlstp.log, Mssql7\Install\Cnfgsvr.out, and Mssql7\Log\Errorlog.* files on the remote computer. The contents of the Sqlstp.log file are well documented in SQL Server 7.0 Books Online, which also contains a "Setup Troubleshooting" section.