Microsoft KB Archive/929151

= A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005 =

Article ID: 929151

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard X64 Edition

-



Bug #: 444933 (SQLBUDT)



SYMPTOMS
When you try to install a service pack on an x64-based passive node cluster computer that is running Microsoft SQL Server 2005, the service pack does not install on the passive node. Additionally, the following messages may be logged in the installation log:

Message 1

Product: Database Services (64-bit)

Message 2

Database Services (64-bit) (RTM 1399 ENU SQLFOCL-1) - Failure

Message 3

Details: No passive nodes were successfully patched

The following error messages are logged in the passive node of the installation log:

Error message 1

MSI (s) (2C!BC) [23:38:33:530]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 29530. Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11001 (No such host is known.)

Error message 2

Error 29530. Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11001 (No such host is known.)



CAUSE
This problem may occur when DNS resolution of the cluster virtual server name fails.



WORKAROUND
To work around this problem, add the virtual server host name and the associated IP address to the LMOSTS file on the local computer. The LMHOSTS file is located in the following folder:

%SystemRoot%\System32\Drivers\Etc



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb KB929151

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.