Groups | Blog | Home
all groups > sql server clustering > january 2006 >

sql server clustering : Cluster install failing


Brad
1/27/2006 8:43:02 AM
When installing SQL 2005 on a 2 node cluster, the install fails saying setup
on the remote machine failed, check the task scheduler log. The log on the
remote machine says "Unable to start task....Access is denied". Any idea how
to get around this?

Brad
1/27/2006 9:17:02 AM
I also need to mention that I have Act as part of the operating system and
log on as a service rights on both nodes.

[quoted text, click to view]
Brad
1/27/2006 9:34:03 AM
Yes, thank you. The domain account I am using is already a member of the
admin group on both nodes. The error still persists.

[quoted text, click to view]
Brad
1/27/2006 10:22:01 AM
I didn't provide that information up front but the account is a member of the
admin group on both boxes.

[quoted text, click to view]
Michael Hotek
1/27/2006 11:13:58 AM
Permissions. The account that you are using to install the failover cluster
instance must be a member of the local admin group on each machine. (The
service accounts related to SQL Server do NOT need to be.)

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

Geoff N. Hiten
1/27/2006 12:25:56 PM
You have to install using a domain account that is a member of the local
administrators group on each server.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



[quoted text, click to view]

Nik Marshall-Blank
1/29/2006 2:33:37 PM
Hi,

But is it the LOCAL ADMIN ACCOUNT not domain admin account?
--
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria

[quoted text, click to view]

Brad
1/30/2006 6:35:27 AM
Yes, it is in the local admin group on both machines.

[quoted text, click to view]
Geoff N. Hiten
1/30/2006 12:40:23 PM
Make sure the task scheduler service is enabled and running on all nodes.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


[quoted text, click to view]

MCD
2/21/2006 12:30:28 PM
Did you ever get a resolution on this ? I am having the exact same
problem.

I have checked all the obvious problems, like permissions, task
scheduler service running, etc.

I am going to call Microsoft Support tomorrow if I can't figure this
out.

[quoted text, click to view]
Artur Bittencourt
2/24/2006 8:32:24 AM
I have the exactly same problem here. Does anyone have a solution for
this ?

Thank you for your attention.

Artur



Jan Vandenpanhuyzen
3/6/2006 7:35:38 AM

Hi Brad,

We have the same problem trying to install SQL Server 2005 on a 2node
cluster.
We haven't found a solution on this so if you did I would be very happy
to know what solved the problem. :o)

Thanks in advance for your help.

Jan


Artur Bittencourt
3/6/2006 8:05:50 AM
Hi Jan,

I've got a solution for this issue. It's so simple you won't believe it.
You have to logout from the remote node before you install SQL 2005 in
the cluster. If you are logged on the remote node, the installation
process will fail. I was wondering why Microsoft doesn't mention this
simple thing anywhere :-\

Artur Bittencourt
Network Administrator
www.1800gotjunk.com
artur(dot)bittencourt(at)1800gotjunk.com

stiffl3r
3/30/2006 6:08:15 AM
The "fix" below worked out GREAT!

stiffl3r

[quoted text, click to view]
AddThis Social Bookmark Button