sql unavailable by IP address -- sql server clustering

Nerses
7/17/2004 12:54:38 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

Nerses
7/17/2004 1:56:42 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\ClusterIpAddr

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

[quoted text, click to view]

uttamkp NO[at]SPAM online.microsoft.com
7/19/2004 4:20:28 PM

The supported method to change the virtual IP address for SQL Server 2000 virtual instance is documented in

HOWTO: Change the Network IP Addresses on a Virtual SQL Server
http://support.microsoft.com/?kbid=244980

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : sql unavailable by IP address