Tuesday, October 21, 2014

3 Configure Single Node SQL Cluster after SQL Server installation.

Single node cluster is not recommend HADR solution. One of the reason I do this is SQL Server AlwaysOn require the “Windows failover Cluster name” for the SQL Server. 

Below screenshot from one of the standalone installation. The host does not have failover cluster feature installed, the SQL Server instance property is complete gray out

image

Add Failover Clustering feature . This would not cause down time on the Windows host and SQL server instance.

image

image

Add the Cluster Name and IP address

image

image

From SQL Server configuration manger , we can see it found the cluster name.

image

If you already configure SQL server to listen on any port.

image

This is effective immediately .

image

This test prove that we can add Windows Failover clustering after SQL server is installed.

3 comments:

  1. It's very great to see your post!I like it .I'm looking forward to you in the next post.Thank you .There is a sd card recovery for mac activation code to you.

    ReplyDelete
  2. I'm glad to see this post. By the way, you may be interested in replica ray bans.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates