Friday, December 30, 2016

Disable port from dynamic to static on SQLcluster 2012

Step1 :

Stop SQL services

Get cluster resource from powershell

PS C:\Users\Administrator.DOMAIN> Get-ClusterResource "SQL Network Name (sqlclustername)"


Step 2:

Remove checkpoint using below command from powershell

Get-ClusterResource "SQL Network Name (sqlclustername)" | Remove-ClusterCheckpoint -RegistryCheckpoint


Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\Cluster' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"): Y


Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\MSSQLServer' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\Replication' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\Providers' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\SQLServerSCP' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\CPE' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\SQLServerAgent' on resource 'SQL Network Name (sqlclustername)'?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Remove-ClusterCheckpoint
Are you sure you want to remove registry checkpoint 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.sqlclustername\Cluster' on resource 'SQL Network Name (sqlclustername)'?

[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):



Step 3 :

Chage port from network protocals




Step 4 : Repeat above steps on remaining nodes


Step 5 : Add Checkpoints from powershell

Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\MSSQLServer" 
Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\Replication" 
Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\Providers" 
Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\SQLServerSCP" 
Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\CPE" 
Add-ClusterCheckpoint -ResourceName "SQL Network Name (sqlclustername)" -RegistryCheckpoint "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.InstanceID\SQLServerAgent" 


Step 6: Now all set. Start the cluster services