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
Time: 1:10:19 PM
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.
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