Hi all
I've got a sql 2005 active/passive cluster on win2k3 servers.
In cluster admin under sql server 2005 group resources i've got:
3 physical disks
IP Address - ip address of mycluster server
Network Name - mycluster-depends on Ip address
SQL Server - sql server - depends on 3 physical disks, network name and ip
address.
SQL Server Agent - SQL agent - depends on SQL Server
SQL Full-Text - also depends on sql server
All my dependencies and resources are correct.
so when i try to bring online the sql server it says failed under state.
I try to start the sql server from config manager it doesn't start. give me
an error:
"The request failed or service did not respond in timely fashion. consult
event log"
I go into the Event Viewer under application i see this error:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 26054
Date: 10/17/2006
Time: 1:10:19 PM
User: N/A
Computer: mycluster1
Description:
Could not find any IP address that this SQL Server instance depends upon.
Make sure that the cluster service is running, that the dependency
relationship between SQL Server and Network Name resources is correct, and
that the IP addresses on which this SQL Server instance depends are
available. Error code: 0x103.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: c6 65 00 00 10 00 00 00 Æe......
0008: 0b 00 00 00 4e 00 59 00 ....m.y.
0010: 43 00 53 00 51 00 4c 00 c.l.u.s.
0018: 49 00 4d 00 44 00 42 00 t.e.r.1.
0020: 00 00 00 00 00 00 ......
I double checked everything that this error refers to and still i cannot
start sql server.
Can someone help me out with this?
Thanks for all your help in advance
Geoff N. Hiten - 17 Oct 2006 19:15 GMT
Your dependencies are not correct. Remove the direct dependency of the SQL
Server on the IP address. The Network name service dependency will cover
that case.

Signature
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
> Hi all
>
[quoted text clipped - 57 lines]
>
> Thanks for all your help in advance
Alex S - 18 Oct 2006 17:32 GMT
Geoff thanks for the reply. But by the time i had to try it out our network
guys started rebuilding both of the machines.
I'll keep in mind this when i start installing the sql server 2005 on a
cluster.
> Your dependencies are not correct. Remove the direct dependency of the
> SQL Server on the IP address. The Network name service dependency will
[quoted text clipped - 61 lines]
>>
>> Thanks for all your help in advance