dbTalk Databases Forums  

sql unavailable by IP address

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss sql unavailable by IP address in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nerses
 
Posts: n/a

Default sql unavailable by IP address - 07-17-2004 , 02:54 PM






Hi there,

I have a fail-over cluster that consists of two nodes.
Active/Passive (one owner preferred). Two nods connected
to external disk array. Everything has been working fine
in this environment except of one thing:

The Virtual SQL server is available by the NetBIOS name,
but is not available by the virtual IP address. I have
checked the domain controller; it has an entry in DNS for
the NetBIOS name pointing to the correct IP address. The
servers can ping the NetBIOS name and it comes back with
the correct IP address. And yet, when I put the IP address
in my applications instead of the NetBIOS name- they do
not work (and they are working perfectly fine when I
change the IP address to another non-clustered machine).

Any ideas?

Thanks,
Nerses


Reply With Quote
  #2  
Old   
Nerses
 
Posts: n/a

Default sql unavailable by IP address - 07-17-2004 , 03:56 PM






I actually found the solution for the problem. The problem
was that earlier I had to change the IP addresses and
subnets for every member of the cluster and every cluster
service due to relocation. And even though I have followed
through the Cluster Administrator to do all of the
necessary changes, it appears that the old record still
remained in the registry at the following address:

HKLM\Software\Microsoft\MSSQLServer\Cluster\Cluste rIpAddr

After I manually went to the registry and changed the IP
address everything worked fine. I am surprised though,
that the Cluster Administrator did not do the job
thoroughly.

Hopefully this will help someone who has a similar problem.
Cheers,
Nerses



Quote:
-----Original Message-----
Hi there,

I have a fail-over cluster that consists of two nodes.
Active/Passive (one owner preferred). Two nods connected
to external disk array. Everything has been working fine
in this environment except of one thing:

The Virtual SQL server is available by the NetBIOS name,
but is not available by the virtual IP address. I have
checked the domain controller; it has an entry in DNS for
the NetBIOS name pointing to the correct IP address. The
servers can ping the NetBIOS name and it comes back with
the correct IP address. And yet, when I put the IP
address
in my applications instead of the NetBIOS name- they do
not work (and they are working perfectly fine when I
change the IP address to another non-clustered machine).

Any ideas?

Thanks,
Nerses

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.