Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vime
Starting Member
1 Post |
 Posted - 2003-11-10 : 05:28:29
|
| The problem we have been experiencing is as follows :-When connecting to the SQL Resource IP address from the Web Server, very basic test using ping, occasionally the web server will lose connectivity,when connectivity is lost the following conditions are trueThe server cannot ping the SQL resource IP address The server is unable to make a TCP connection to the server (tested using and ODBC to TCP Port 1433)The server can ping the Windows cluster address, and the individual servers IP addresses The servers arp cache (arp -a) shows that the SQL resource IP address has been given a MAC address from a card on the passive SQL server.If you delete the arp cache (arp -d *) sometimes the sever will get connectivity back sometime not (I am presuming you have a 2/4 chance of getting a MAC address on the active SQL server.If you add a static arp entry (arp -s ??-??-??-??-??-??) to set SQL resource IP address to a MAC address of a card on the active SQL server you get connectivity back.I have seen the situation where that after you add a static arp entry to the active SQL server, it works for a while then the static arp entry changes to a MAC address of the passive none and therefore stops working.The problem was still observed after moving the web and sql servers to a hub, thus removing any switching problems. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 12:20:26
|
| This doesn't sound like a SQL Server problem. This sounds more like a Windows cofiguration problem. I would recommend contacting the vendor who assisted with your cluster configuration.Tara |
 |
|
|
|
|
|
SQL Server 2000 cluster - ODBC problem