The SQL Server failover cluster instance name 'INST3' already exists as a clustered resource. Specify a different failover cluster instance name.

I got the below mentioned error while installing sql server 2008 failover cluster.


The SQL Server failover cluster instance name 'INST3' already exists as a clustered resource. Specify a different failover cluster instance name.


Resolution


1) Run Cluster Res in the command prompt. Get the orphaned resource from  
    the  list.
2) Delete the orphaned user using the below command.
        cluster RES "<Resource Name>" /Delete
3) Continue the installation after this.


         

SQL Server 2008 Cluster Add Node Installation Error - SKU is Invalid

I got the below error while adding node to the Second Instance of my SQL Server 2008 Cluster.

Solution

1) Open DefaultSetup file inside corresponding folder ( X64 for 64 bit processor, X86 for 32 bit).

2) Remove or Comment the PID line.

3) During the Installation give the product key manually.

SQL Server 2005 Cluster Error - Error: 422

One of my friend got the below error in our SQL Server 2005 environment.


000016bc.000009f4::2011/03/02-00:46:48.840 ERR  SQL Server <SQL Server (DWHCI01)>: [sqsrvres] StartResourceService: StartService (MSSQL$DB1) failed.  Error: 422
000016bc.000009f4::2011/03/02-00:46:48.840 ERR  SQL Server <SQL Server (DWHCI01)>: [sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 422)
000016bc.000009f4::2011/03/02-00:46:48.840 ERR  SQL Server <SQL Server (DWHCI01)>: [sqsrvres] OnlineThread: Error 422 bringing resource online
Application logs is showing similar errors.


Resolution
Found that SQL Server service is in Disabled status. Made the same to Manual and bring the resource online.