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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2007-04-19 : 20:40:38
|
| We got a cluster server with Win2K3 sp1 with SQL 2K sp4, the server just re-start without failover, can see the following on the application log:[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed[sqsrvres] printODBCError: sqlstate = 01000; native error = 2746; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).It cause both instances on the server get restarted itself, did a search on the net and not much luck with it. Got some people saying its because of the clsuter admin can't query SQL and it just fail itself. And its using Name pipe rather then TCP/IP, so by putting an alias there will get the problem solved. But I would like to be sure. Does anyone have that issue before? And found a solution?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 09:35:49
|
| Never saw that on my clusteres. Any error in sql server log? |
 |
|
|
SatyaSKJ
Starting Member
46 Posts |
|
|
DBriles
Starting Member
9 Posts |
Posted - 2007-05-10 : 16:51:28
|
| In Cluster Administrator are the SQL Server service resources set to "Affect the Group"? If not, a service restart will not initiate a failover. |
|
|
|
|
|
|
Server re-started