Microsoft KB Archive/249802
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:
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:
NOTE: Also make sure that the ADMIN$ shares are on both nodes.
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.
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