Clustered SQL -- what is created in DNS?

  • So I built a nice 3-node, 3-Instance SQL cluster, and the cluster also has Clustered SSAS and Clustered MSDTC. My account is a Domain Admin.

    When I look in DNS, I see nothing for these five clustered resources -- no names, no IP addresses, nowhere. There are records for the actual physical servers themselves, though.

    Should stuff have been automatically created in DNS for the clustered resources? If so, does that mean something is wrong? If so can I manually create whatever needs to be created? And if so is this documented somewhere? (google has resulted in no joy)

    Thanks!

  • Windows 2003 or Windows 2008 domain?

    Each virtual network name would be registered in Active Directory and would also have a DNS host (A) record created.

    Is your DNS zone AD integrated?

    Do you have multiple AD sites?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I asked one of our Domain Admins, and he said:

    - The domain functional level is at 2003 (even though servers are 2008).

    - AD and DNS are integrated.

    - Yes we do have multiple sites.

    Does this help? Should these records have been automatically created in DNS, or something?

  • As DNS is AD integrated it can take a short time to replicate across DCs. Remember you're dealing with a multi master replication model here and it gets even worse when you have multiple sites as replication can be slowed here to (admin controlled).

    What happens when you ping the virtual ip and then try a ping -a on the virtual ip?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply