Hi,

I am saying that setup dected all the instances but setup failed for one of the database services i..e one instance out of two. Please also note that both the nodes are on separate active\active clustered. I have tried with all the options like browsew service is online as it is not on clustered group, TCP ip is enabled in ms sql server configuration manager, and i have tried to put the virutual name and ip address of the node in LMHOSTS.sam file but still it is not working.

I am pasting below the text of Summary.txt file.

Please see if any has got any fix for it.

Time: 09/28/2008 06:51:54.039

KB Number: KB948109

Machine: KDCPSQL05N2

OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)

Package Language: 1033 (ENU)

Package Platform: x64

Package SP Level: 2

Package Version: 3068

Command-line parameters specified:

Cluster Installation: Yes

Log Location on Passive Nodes:

(KDCPSQL05N2) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

(KDCPSQL05N1) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************

Prerequisites Check & Status

SQLSupport: Passed

**********************************************************************************

Products Detected Language Level Patch Level Platform Edition

SQL Server Database Services 2005 (PAML) ENU SP2 2005.090.3068.00 x64 ENTERPRISE

SQL Server Database Services 2005 (PSQL02) ENU SP2 2005.090.3042.00 x64 ENTERPRISE

SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3068 x64 ENTERPRISE

**********************************************************************************

Products Disqualified & Reason

Product Reason

SQL Server Database Services 2005 (PAML) This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.

**********************************************************************************

Processes Locking Files

Process Name Feature Type User Name PID

MSSQL$PSQL02 SQL Server Database Services Service 1820

**********************************************************************************

Product Installation Status

Product : SQL Server Database Services 2005 (PAML)

Product Version (Previous): 3068

Product Version (Final) :

Status : NA

Log File :

Error Description : This installation must be run from the active node. You are running it from a passive node. To proceed, cancel the installation and run it again from the active node.

----------------------------------------------------------------------------------

Product : SQL Server Database Services 2005 (PSQL02)

Product Version (Previous): 3042

Product Version (Final) :

Status : Failure

Log File :

Error Number : 11009

Error Description : No passive nodes were successfully patched

----------------------------------------------------------------------------------

Product : SQL Server Tools and Workstation Components 2005

Product Version (Previous): 3068

Product Version (Final) :

Status : Not Selected

Log File :

Error Description :

----------------------------------------------------------------------------------

**********************************************************************************

Summary

No passive nodes were successfully patched

Exit Code Returned: 11009

Thanks,

Santosh Singh