Wednesday, August 5, 2015

SQL Server AG listener creation with customized OU

Symptom:

USE [master]
GO
ALTER AVAILABILITY GROUP [TestDB1_AG]
ADD LISTENER N'VMMAG01' (
WITH IP
((N'10.0.2.201', N'255.255.255.0')
)
, PORT=1433);

Msg 19471, Level 16, State 0, Line 3
The WSFC cluster could not bring the Network Name resource with DNS name 'VMMAG01' online. The DNS name may have been taken or have a conflict with existing name services, or the WSFC cluster service may not be running or may be inaccessible. Use a different DNS name to resolve name conflicts, or check the WSFC cluster log for more information.

Msg 19476, Level 16, State 4, Line 3
The attempt to create the network name and IP address for the listener failed. The WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator.

How to fix:

If servers in default OU, for example, it works per normal.

image

Otherwise, if in non-default OU, for example below, need to pre-stage the virtual computer objects (VCOs) and grant full right of Cluster Computer Object (CNO) on VCOs.

image

16 comments:

  1. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. creare linea abbigliamento

    ReplyDelete
  2. This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. track your shipment from chinapost with your tracking number

    ReplyDelete
  3. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. 바카라사이트

    ReplyDelete
  4. I am definitely enjoying your website. You definitely have some great insight and great stories. 송파 대우이안 이스트원 아파트

    ReplyDelete
  5. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. goldenslot

    ReplyDelete
  6. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! สล็อต

    ReplyDelete
  7. Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post. slot

    ReplyDelete
  8. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. Entrümpelung

    ReplyDelete
  9. Investigate that states how prescient information examination discovering its way in different businesses: Data Analytics Courses

    ReplyDelete
  10. It is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post. SEO

    ReplyDelete
  11. health care analytics
    360DigiTMG has developed the Certification Program in Healthcare Analytics. This course is meticulously designed to suit both Healthcare practitioners, IT Business Analysts and Data Scientists.
    https://360digitmg.com/india/life-sciences-and-healthcare-analytics-certification-programme

    ReplyDelete
  12. Only aspire to mention ones content can be as incredible. This clarity with your post is superb and that i may think you’re a guru for this issue. High-quality along with your concur permit me to to seize your current give to keep modified by using approaching blog post. Thanks a lot hundreds of along with you should go on the pleasurable get the job done. buy instagram likes famoid

    ReplyDelete
  13. I think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, https://serverbrowse.com/

    ReplyDelete
  14. I'm constantly searching on the internet for posts that will help me. Too much is clearly to learn about this. I believe you created good quality items in Functions also. Keep working, congrats! https://serverbrowse.com/

    ReplyDelete
  15. Thank you for taking the time to publish this information very useful! instagram likes app download apk

    ReplyDelete
  16. it's really cool blog. Linking is very useful thing.you have really helped.
    360digitmg business analytics courses

    ReplyDelete