Microsoft KB Archive/249802

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:14, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Article ID: 249802

Article Last Modified on 1/3/2002



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition



This article was previously published under Q249802

SYMPTOMS

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

CAUSE

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.

WORKAROUND

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.


-or-

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


MORE INFORMATION

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'.
\\TBL-CS2\Admin$\sqlsp.log
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