Make sure that your SQL Cluster Service account has the sufficient
privileges on the other node of your cluster where you are seeing the
failure. Also, make sure that the SQL Cluster Service account is setup
as a domain account in your new domain and is able to be used on both
nodes.

This can also happen if your MS Cluster Service account is having the
same problem.

Did the failover fail before you installed SQL?

Bill Reed

-----Original Message-----
From: lparker
[mailto:mssqldba-ezmlmshield-x27909999.[Email address protected]
Sent: Thursday, September 28, 2006 3:03 PM
To: LazyDBA Discussion
Subject: SQL Cluster - HELP


I have a SQL Cluster that I just moved from one domain to another.
IP Address and everything was changed successfully.
However, on one server SQL server starts fine but whenever I fail over
to
the other server SQL will not come up once everthing has failed over.
I can fail back over to the other server and SQL starts up fine.

Does anyone know why SQL is starting on and not the other?

Leon Parker
Lorillard Tobacco Company
Database Administrator
336-335-6934




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page