November 15, 2011 at 4:04 am
I've a cluster with 2 nodes.
All resources are now on node 1 and I'm logged in at server Node2 to remove the SQL Server installation.
When starting the installation center, selecting the remove node option, everything is ok.
But after the 'Ready to remove node' final report, there comes an error in 'Remove Node Progress'!
Error: The cluster resources is not available. (Exception from HRESULT: 0x8007138E)
Even restarting the server and retrying gave the same error...
I cann't find info on the web.. 🙁
November 15, 2011 at 4:12 am
The error popus just after 'Validating Feature Settings'... hope this gives some more info.
I just tried to remove node on the active node: same error 🙁
November 15, 2011 at 4:22 am
To remove a node from an existing SQL Server failover cluster
1.Insert the SQL Server installation media. From the root folder, double-click setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe. If the Microsoft SQL Server 2008 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to quit the SQL Server installation.
2.Windows Installer 4.5 is required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart and then start SQL Server Setup.exe again.
3.When prerequisites are installed, the Installation Wizard launches the SQL Server Installation Center. To remove a node to an existing failover cluster instance, click Maintenance in the left-hand pane, and then select Remove node from a SQL Server failover cluster.
4.The System Configuration Checker will run a discovery operation on your computer. To continue, click OK. Setup log files have been created for your installation. For more information about log files, see How to: View and Read SQL Server Setup Log Files.
5.The Installation Wizard installs SQL Server prerequisites if they are not already on the computer. They include the following:
SQL Server Setup Support Files
To install prerequisites, click Install.
6.The System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue.
7.On the Cluster Node Configuration page, use the drop-down box to specify the name of the SQL Server failover cluster instance to be modified during this Setup operation. The node to be removed is listed in the Name of this node field.
8.The Ready to Remove Node page displays a tree view of options that were specified during Setup. To continue, click Remove.
9.During the remove operation, the Remove Node Progress page provides status.
10.The Complete page provides a link to the summary log file for the remove node operation and other important notes. To complete the SQL Server remove node, click Close. For more information about Setup log files, see How to: View and Read SQL Server Setup Log Files.
November 15, 2011 at 4:44 am
Till step 8 everything is ok!
In step 9, the error popups.
I've checked my system and I've found an error in the Failover Cluster Manager.
There was a group 'Available storage' in error --> I've delete this recource group and now the remove is done!
But still strange, that 'Available Storage' didn't had to do anything with the SQL Failover instance
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply