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

20 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. 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
  3. I am definitely enjoying your website. You definitely have some great insight and great stories. 송파 대우이안 이스트원 아파트

    ReplyDelete
  4. 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
  5. 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
  6. 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
  7. Investigate that states how prescient information examination discovering its way in different businesses: Data Analytics Courses

    ReplyDelete
  8. 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
  9. 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
  10. Thank you for taking the time to publish this information very useful! instagram likes app download apk

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

    ReplyDelete
  12. The framework can be secured much progressively through the working framework. Change Site URL Using MySQL

    ReplyDelete
  13. I am searching exactly about the SQL server ag listener creation. Your post ends my search. It is a great source for users. Thanks for sharing with us.

    ReplyDelete
  14. Admiring the time and effort you put into your blog and detailed information you offer!.. Europa-Road targonca szállítás Debrecen

    ReplyDelete
  15. Organization Burden Adjusting (NLB) is one of the server repetition offered by Microsoft which is not difficult to introduce, oversee, and keep up. how to choose the right vpn server

    ReplyDelete
  16. Quite a while later, Tech would endeavor to reappear the SEC yet their application was denied, in huge part because of the resistance of Georgia. vpn for pc free

    ReplyDelete
  17. At the point when instructors are new to the technological devices, they are probably going to abdomen additional time attempting to utilize them the technological programming that is utilized the most as per understudies is PowerPoint. Understudies grumble that educators use it rather than their illustration plan. Concise Finance Wandsworth UK Retirement Mortgage

    ReplyDelete
  18. This kind of assault however exceptionally tedious is one that gives the most possibly harming security opening. https://onohosting.com/

    ReplyDelete
  19. On the off chance that your association doesn't have anybody with these abilities and you are kept from enlisting remotely, or can't draw in this range of abilities, think about preparing your DBA. Ensure that you plan the preparation early enough in the task so the DBA is ready for the arranging stage.
    https://hostinglelo.in/

    ReplyDelete
  20. Minecraft is an MMO (Massive Multiplayer Online) game written in Java, developed by only one person at the beginning whose name is Markus Alexej Persson, also known as Notch. Best Minecraft Servers

    ReplyDelete