"mjb9999@hotmail.com" wrote:

> I may not have been clear enough. You're right, it isn't that some
> resources in the group fail over and others don't (so the group as a
> whole doesn't actually fail over), but some of them come online where
> the others will not. The SQL Server Network Name, IP Address, and
> Physical Disk resources will come online in the second node, but the
> SQL Server, SQL Server Agent, and Full Text resources won't come online
> unless the MSDTC resource group is running on the node. If MSDTC is
> not running on the new node, the group will attempt to fail over. The
> 3 resources that don't come online stay in a status of "Online
> Pending". After trying to come online 3 times, the group will fail
> back to the original node. Also, the following 2 errors show up in the
> Application event log.
>
> Event Type: Error
> Event Source: MSSQL$SQL1
> Event Category: (3)
> Event ID: 17052
> Date: 3/31/2006
> Time: 12:31:36 PM
> User: N/A
> Computer: SQLNODE1
> Description:
> [sqsrvres] OnlineThread: Error 5b4 bringing resource online.
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 9c 42 00 40 01 00 00 00 Å“B.@....
> 0008: 0b 00 00 00 53 00 51 00 ....S.Q.
> 0010: 4c 00 53 00 45 00 52 00 L.S.E.R.
> 0018: 56 00 45 00 52 00 31 00 V.E.R.1.
> 0020: 00 00 00 00 00 00 ......
>
>
> Event Type: Error
> Event Source: MSSQL$SQL1
> Event Category: (3)
> Event ID: 17052
> Date: 3/31/2006
> Time: 12:31:36 PM
> User: N/A
> Computer: SQLNODE1
> Description:
> [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status
> 5b4)
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 9c 42 00 40 01 00 00 00 Å“B.@....
> 0008: 0b 00 00 00 53 00 51 00 ....S.Q.
> 0010: 4c 00 53 00 45 00 52 00 L.S.E.R.
> 0018: 56 00 45 00 52 00 31 00 V.E.R.1.
> 0020: 00 00 00 00 00 00 ......
>