"Alex S" <alexsdba@aol.com> wrote in message
news:OHuuVBh8GHA.2288@TK2MSFTNGP05.phx.gbl...
>
> 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" <SQLCraftsman@gmail.com> wrote in message
news:eFKyKhh8GHA.2288@TK2MSFTNGP05.phx.gbl...
> 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.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Alex S" <alexsdba@aol.com> wrote in message
> news:OHuuVBh8GHA.2288@TK2MSFTNGP05.phx.gbl...
>>
>> 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
>>
>>
>
>