Cluster install failing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 27 Jan 2006 16:43 GMT

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?

Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Michael Hotek - 27 Jan 2006 17:13 GMT

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

Signature

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.

> When installing SQL 2005 on a 2 node cluster, the install fails saying
> setup
[quoted text clipped - 5 lines]
>
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Brad - 27 Jan 2006 18:22 GMT

I didn't provide that information up front but the account is a member of the
admin group on both boxes.

> 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
[quoted text clipped - 9 lines]
> >
> > Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

MCD - 21 Feb 2006 20:30 GMT

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.

> I didn't provide that information up front but the account is a member of the
> admin group on both boxes.
[quoted text clipped - 19 lines]
> > >
> > > Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Artur Bittencourt - 24 Feb 2006 16:32 GMT

I have the exactly same problem here. Does anyone have a solution for
this ?

Thank you for your attention.

Artur

Reply to this Message

Brad - 27 Jan 2006 17:17 GMT

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.

> 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?
>
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Geoff N. Hiten - 27 Jan 2006 17:25 GMT

You have to install using a domain account that is a member of the local
administrators group on each server.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>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 clipped - 8 lines]
>>
>> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Brad - 27 Jan 2006 17:34 GMT

Yes, thank you. The domain account I am using is already a member of the
admin group on both nodes. The error still persists.

> You have to install using a domain account that is a member of the local
> administrators group on each server.
[quoted text clipped - 11 lines]
> >>
> >> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Nik Marshall-Blank - 29 Jan 2006 14:33 GMT

Hi,

But is it the LOCAL ADMIN ACCOUNT not domain admin account?

Signature

Nik Marshall-Blank MCSD/MCDBA
Linz, Austria

> 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 clipped - 17 lines]
>> >>
>> >> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Brad - 30 Jan 2006 14:35 GMT

Yes, it is in the local admin group on both machines.

> Hi,
>
[quoted text clipped - 20 lines]
> >> >>
> >> >> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition

Reply to this Message

Geoff N. Hiten - 30 Jan 2006 17:40 GMT

Make sure the task scheduler service is enabled and running on all nodes.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Yes, it is in the local admin group on both machines.
>
[quoted text clipped - 29 lines]
>> >> >> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev
>> >> >> Edition

Reply to this Message

Jan Vandenpanhuyzen - 06 Mar 2006 15:35 GMT

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

Reply to this Message

Artur Bittencourt - 06 Mar 2006 16:05 GMT

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

Reply to this Message

stiffl3r - 30 Mar 2006 15:08 GMT

The "fix" below worked out GREAT!

stiffl3r

> Hi Jan,
>
[quoted text clipped - 10 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message