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 |
|
cblatchford
Starting Member
40 Posts |
 Posted - 2007-09-20 : 12:40:08
|
| Pulling hair out as we speak, when failing over to the B Node the SQL Server Agent spews out these messages:[sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedthen..[sqsrvres] ODBC sqldriverconnect failedThese error messages in event-viewer just keep on coming. Strangely, going into the ODBC Settings in control panel all the drivers are gone when trying to add a connection! I've checked the sql versions are the same, cluster file versions etc the cluster and disks are failing over perfectly, it's just the SQL Server Agent which is not starting..ANyone come across this before!? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-20 : 23:52:43
|
| Tried reinstall mdac? |
 |
|
|
|
|
|
AGH! SQL 2000 Cluster probs..