Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Clustering

Interview Question :: Have a 4 node windows 2003 cluster with 3 instances of SQL.Some nodes hang with an IP conflict.WHY??EMC SAN

What would cause a node or two from a windows cluster to arbitrarily complain of and an IP conflict and hang till you reboot the machine. If you need more detail I will give it to you.

Answers to "Have a 4 node windows 2003 cluster with 3 instances of SQL.Some nodes hang with an IP conflict.WHY??EMC SAN"

RE: Have a 4 node windows 2003 cluster with 3 instances of SQL.Some nodes hang with an IP conflict.WHY??EMC SAN?
An IP conflict has nothing to do with SQL, or even the operating system for that matter. It's a problem with your DHCP server -- the system that's handing out your IP addresses. This will be the router or cluster controller that the systems are connected to, I think. The simplest long-term solution would just be to reconfigure the windows systems with static IP addresses. If that's not possible (e.g., if the SAN for some reason requires dynamic IP addresses), make sure all the Windows machines are up and running and power cycle your DHCP server. If THAT'S not possible, your DHCP server might have a command to clear its address cache -- it's the cache that's causing the symptom you describe because it has the wrong entry for at least one system. OR, you could do a ipconfig /renew (in a cmd window) on each of the servers. The systems shouldn't hang when you have an IP conflict. You may have to stop SQL Server (and stop it from starting automatically) via Administrative Tools -> Services while you work on the IP conflict problem. Send me email (via the magic link in my profile) if you want to discuss this.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Clustering

Interview Question :: Have a 4 node windows 2003 cluster with 3 instances of SQL.Some nodes hang with an IP conflict.WHY??EMC SAN

Top Tags