Groups | Blog | Home
all groups > sql server clustering > december 2005 >

sql server clustering : add second node to sql2005 clustered


dpasella NO[at]SPAM gmail.com
12/21/2005 3:23:20 AM
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.
Geoff N. Hiten
12/21/2005 8:55:33 AM
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


[quoted text, click to view]

dpasella NO[at]SPAM gmail.com
12/27/2005 9:29:49 AM
[quoted text, click to view]

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.
Geoff N. Hiten
12/27/2005 1:29:57 PM
Make sure the Windows Scheduler is running on the remote node.

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


[quoted text, click to view]

dpasella NO[at]SPAM gmail.com
12/28/2005 8:40:08 AM
Yes, the service is running (local service).
It is the first control that I have made

Thanks
..yo.mo.



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