Hi:

I'm trying to install MS SQL 2005 Standard x64 to a two node Windows Server
2003 R2 SP2 cluster.

I've setup the cluster as per MS requirements and tested failover, The
cluster seems to be working well.

When I go through the Install and select failover clustering for the
Database and Analysis services, all seems to go well until it gets to the
end, I get a failure on the second (passive) node.

On the passive node I find that there is a Task Scheduler job set, SQL
Server Remote Setup.job that is reporting this error:

"SQL Server Remote Setup .job" (setup.exe) 12/4/2007 12:40:14 PM ** ERROR
**
Unable to start task.
The specific error is:
0x80070005: Access is denied.
Try using the Task page Browse button to locate the application.

The only MS info, I've found is not to be in RDP on the second node. I've
tried that and even did an install from the console on the first node (No
Remote Desktop sessions at all). Same error.

I've made sure that the account used is part of the local administrators
group on both nodes and has the following rights:

Act as part of operating system
Logon as a batch job
Logon as a Service

I have been going around on this for several days and cannot come to a
solution.

Is it that the second node doesn't have access to the setup files? I tried
installing from the DVD on the primary node and copied the files to a
directory on the primary and shared it. Same error.

Thanks

Usually, the last thing you tried, moving the setup files, fixes this type
of issue.

Have you tried running the cluster install but only for the first node, then
adding the node via add/remove programs? I sometimes find mirroring the
regular cluster setup logic (build a single-node cluster and add on) helps.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Paul Hons" <Paul.Hons (AT) unt (DOT) edu> wrote

Geoff N. Hiten wrote:
Have you logged into both systems with the service account that you will
be using to run SQL Server? If not, make sure you log into both
machines with that account to create the user profile. For whatever
reason - without the user profile the task scheduler jobs cannot be started.

At least that is what worked for me.

BTW - before you restart your install make sure you uninstall the setup
files or you will get another error.

Jeff

Geoff N. Hiten wrote:
Have you logged into both systems with the service account that you will
be using to run SQL Server? If not, make sure you log into both
machines with that account to create the user profile. For whatever
reason - without the user profile the task scheduler jobs cannot be started.

At least that is what worked for me.

BTW - before you restart your install make sure you uninstall the setup
files or you will get another error.

Jeff