Microsoft KB Archive/249802

From BetaArchive Wiki

Article ID: 249802

Article Last Modified on 1/3/2002


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q249802


When you install the Microsoft SQL Server 7.0 service packs from a CD-ROM to a clustered environment, the following error message occurs at the end of the service pack install, which indicates that some components could not be installed on the remote computer:

Configuration of the remote node failed.
You can view summary information in C: temp\remsetup.log


The SQL Server 7.0 service pack setup uses volume administrative shares for installing any components on the remote computer. If you install a SQL Server 7.0 service pack from CD-ROM, the remote installation process fails because no administrative share is created for CD-ROM drives.


To work around this problem, use either of the following methods:

  • Copy the SQL Server 7.0 service pack files from CD-ROM to a local hard disk drive, and then install the service pack from the hard disk drive.


  • Temporarily create an administrative share for the CD-ROM drive. For example, if the CD-ROM drive is drive R, share it as R$.


If the service pack install is unable to access the files needed for installation on the second node, you might see the following error message in the Rmsetup.log file:

SQL Server Remote Setup - Start Time 09/22/99 18:40:40
Script file copied to '\\TBL-CS2\ADMIN$\secnode.iss' successfully.
Installing remote service...
Running '\\TBL-CS1\Z$\ENGLISH\X86\setup\setupsql.exe SecNode=1 -s -f1 \\TBL-CS2\ADMIN$\secnode.iss'...
Remote process exit code was '-1'.
Disconnecting from remote machine...
Service removed successfully.
Remote files removed successfully.
SQL Server Remote Setup - Stop Time 09/22/99 18:41:33

NOTE: Also make sure that the ADMIN$ shares are on both nodes.

Service Packs

You must uncluster SQL Server to install SQL Server service packs. Before you install a SQL Server 7.0 service pack you must use the Failover Cluster Wizard to remove any virtual servers you might have. After you successfully install a SQL Server 7.0 Service Pack, use the Failover Cluster Wizard to rebuild all the virtual servers. During the rebuild you are prompted to insert the SQL Server 7.0 CD-ROM. At that point, insert the original SQL Server 7.0 CD-ROM, not the service pack CD-ROM.

Replication Issues

You must remove replication before you uncluster SQL Server as described in the following article in the Microsoft Knowledge Base:

247110 PRB: Replication Must Be Removed Before Applying Service Pack

Additional query words: SP, Service Pack, fail, sqlsp.log, remsetup.log, cluster

Keywords: kbprb KB249802