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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-23 : 09:05:12
|
| Elizabeth writes "For some reason, the SQL Agent does not start on one of the clusters when it fails over. Here are the error messages on the cluster where it won't work.[298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001] [298] SQLServer Error: 2, ConnectionOpen (CreateFile()). [SQLSTATE 01000] [000] Unable to connect to server; SQLServerAgent cannot start It starts and works fine on one cluster but not the other.Please help.Thanks." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-04-23 : 15:53:22
|
| Are you truly talking about another failover cluster, or just a node within that cluster? Our cluster is configured with SQLAgent set to manual on each node. The instigation of SQL Agent during a failover is supposed to be managed within the Cluster configuration. I would check there first to see if there are any abnormalities. |
 |
|
|
|
|
|
SQLAgentService on Windows Cluster