Tuesday, October 21, 2014

8 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.

8 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
  3. TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
    rattan outdoor furniture nz
    headboard nz
    laptop table nz

    ReplyDelete
  4. This article is really helpful for me. I am regular visitor to this blog. Share such kind of article more in future. Personally i like this article a lot and you can have a look at my services also: I was seriously search for a Salesforce training institutes in ameerpet which offer job assistance and Salesforce training institutes in Hyderabad who are providing certification material. It's worth to join Salesforce training institutes in India because of their real time projects material and 24x7 support from customer desk. You can easily find the best Salesforce training institutes in kukatpally kphb which are also a part of Pega training institutes in hyderabad. This is amazing to join Data science training institutes in ameerpet who are quire popular with Selenium training institutes in ameerpet and trending coureses like Java training institutes in ameerpet and data science related programming coures python training institutes in ameerpet If you want HCM course then this workday training institutes in ameerpet is best for you to get job on workday.

    ReplyDelete
  5. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    workday studio online training
    best workday studio online training
    top workday studio online training


    ReplyDelete
  6. Very well written post. Thanks for sharing this, I really appreciate you taking the time to share with everyone. Project Management Courses

    ReplyDelete

 

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