add second node to sql2005 clustered

Hi, where I can find a guide step-by-step to add a second node to
existing sql2005 cluster?
I have installed an istance only on first node and now I want add the
second one.
I run the setup but i don't see the option to add the new node.
The resources are off-line in the node that i'm going to install.
Thank and sorry for my bad english
..yo.mo.
Cluster modifications are no longer run from the setup CD. Use "Add/Remove
Programs" in control panel to make cluster modifications to SQL 2005
systems.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dpasella@.gmail.com> wrote in message
news:1135164200.016047.77780@.g14g2000cwa.googlegro ups.com...
> Hi, where I can find a guide step-by-step to add a second node to
> existing sql2005 cluster?
> I have installed an istance only on first node and now I want add the
> second one.
> I run the setup but i don't see the option to add the new node.
> The resources are off-line in the node that i'm going to install.
>
> Thank and sorry for my bad english
> .yo.mo.
>
|||> <dpasella@.gmail.com> wrote in message
> news:1135164200.016047.77780@.g14g2000cwa.googlegro ups.com...
>Geoff N. Hiten wrote:
> Cluster modifications are no longer run from the setup CD. Use "Add/Remove
> Programs" in control panel to make cluster modifications to SQL 2005
> systems.
>
Thanks for your reply.
I have used "add/remove programs" but i can't modify the instance.
The log report that:
Complete: SetPackageInstallStateAction at: 2005/11/27 18:19:12,
returned true
Running: DeterminePackageTransformsAction at: 2005/11/27 18:19:12
Complete: DeterminePackageTransformsAction at: 2005/11/27 18:19:14,
returned true
Running: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14
Complete: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14,
returned true
Running: OpenPipeAction at: 2005/11/27 18:19:14
Complete: OpenPipeAction at: 2005/11/27 18:19:14, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2005/11/27 18:19:14
Complete: CreatePipeAction at: 2005/11/27 18:19:14, returned true
Running: RunRemoteSetupAction at: 2005/11/27 18:19:14
<Func Name='CProcessCtrl::GetInstallPath'>
<EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
GetLastError='0'>
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\CASTORE
Complete: RunRemoteSetupAction at: 2005/11/27 18:19:16, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access denied
Running: PopulateMutatorDbAction at: 2005/11/27 18:19:16
Complete: PopulateMutatorDbAction at: 2005/11/27 18:19:16, returned
true
Running: GenerateRequestsAction at: 2005/11/27 18:19:16
Thanks for your help
..yo.mo.
|||Make sure the Windows Scheduler is running on the remote node.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dpasella@.gmail.com> wrote in message
news:1135704589.682373.8140@.g49g2000cwa.googlegrou ps.com...
> Thanks for your reply.
> I have used "add/remove programs" but i can't modify the instance.
> The log report that:
>
> Complete: SetPackageInstallStateAction at: 2005/11/27 18:19:12,
> returned true
> Running: DeterminePackageTransformsAction at: 2005/11/27 18:19:12
> Complete: DeterminePackageTransformsAction at: 2005/11/27 18:19:14,
> returned true
> Running: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14
> Complete: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14,
> returned true
> Running: OpenPipeAction at: 2005/11/27 18:19:14
> Complete: OpenPipeAction at: 2005/11/27 18:19:14, returned false
> Error: Action "OpenPipeAction" failed during execution.
> Running: CreatePipeAction at: 2005/11/27 18:19:14
> Complete: CreatePipeAction at: 2005/11/27 18:19:14, returned true
> Running: RunRemoteSetupAction at: 2005/11/27 18:19:14
> <Func Name='CProcessCtrl::GetInstallPath'>
> <EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
> GetLastError='0'>
> Error: 0x80070005 TaskScheduler::SetTargetComputer for \\CASTORE
> Complete: RunRemoteSetupAction at: 2005/11/27 18:19:16, returned false
> Error: Action "RunRemoteSetupAction" failed during execution. Error
> information reported during run:
> Attempting to determine log files for remote install.
> Connection to remote computer's scheduler service.
> Error: 80070005 Access denied
> Running: PopulateMutatorDbAction at: 2005/11/27 18:19:16
> Complete: PopulateMutatorDbAction at: 2005/11/27 18:19:16, returned
> true
> Running: GenerateRequestsAction at: 2005/11/27 18:19:16
>
> Thanks for your help
> .yo.mo.
>
|||Yes, the service is running (local service).
It is the first control that I have made
Thanks
..yo.mo.
Geoff N. Hiten wrote:[vbcol=seagreen]
> Make sure the Windows Scheduler is running on the remote node.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> <dpasella@.gmail.com> wrote in message
> news:1135704589.682373.8140@.g49g2000cwa.googlegrou ps.com...

add disk to a cluster running sql2005

hi,
I have a windows 2003 sp1 cluster running sql2005.
the DB is installed on S: and i have a R: & U: drive letter that is both
differend disk and runs fine in the cluster.
But i can not see those disks in sql 2005 why ?
the disks are in the same resource group (SQL)
where can I choose the R drive ?
if I choose attach DB I see only the S drive where the DB is installed.
any help is welcome
greetings,
Robert
Hi,
Just fixed it
I added the disk resources to the SQL2005 server resource and now it is
running.
greetings,
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>
|||Just adding them to the SQL Server group is not enough. They have to be
added as a dependency of the SQL Server resource.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>