Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / October 2006

Tip: Looking for answers? Try searching our database.

CLUSTER Error: Could not find any IP address that this SQL Server instance depends upon

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alex S - 17 Oct 2006 18:18 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.