Well - that would probably be frowned upon by your security. That's a
little too much power.

I would suggest that you create a SQL Cluster Service account and a
separate MS Cluster service account in Active Directory Users and
Computers. Then make sure that they both have sufficient privileges.
Then assign them to their appropriate services on each of the nodes.

Here's an article that might help with what specific privileges to give
the service accounts.

http://support.microsoft.com/kb/269196/

You can check the services individually by attempting to start each of
the SQL and Cluster services that are set to Manual. (that's what the
Cluster Manager is trying to do and is failing)

My other thought on this is that that failover failure could be caused
by a dependant resource that is not coming online. When you failover
the cluster, which resource is failing? That would be the one to focus
on..

Bill Reed

-----Original Message-----
From: lparker [mailto:[Email address protected]
Sent: Thursday, September 28, 2006 3:32 PM
To: Reed, William L.
Subject: RE: SQL Cluster - HELP

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


It appears that the SQL Cluster Service account for both servers is
using a
local Administrator account.
Should this be changed on both servers to use a Domain Administrator
account?

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




"Reed William L.

"

<mssqldba-ezmlmsh
To
ield-x81561616.x1 "LazyDBA Discussion"

[Email address protected] [Email address protected]

.com>
cc


09/28/2006 03:20
Subject
PM RE: SQL Cluster - HELP

















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



---------------------------------------------------------------------
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