Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to configure microsoft DNS server (widows server 2008+) to use Microsoft SQL as a data source for DNS data? Is it any guides available?

share|improve this question
up vote 5 down vote accepted

I'm afraid not. MS DNS only offers two options for back end storage, text based zone files, or Active Directory storage.

What is it you want to gain by storing in SQL?

Edit: AD storage basically means that the DNS data is stored in the Active Directory Database, which is effectively the NTDIS.dit file. If you want to access it, you will need to use LDAP commands to do so. You can get some functionality by using Powershell to access AD stored DNS in Server 2008 and later.

share|improve this answer
To use DNS in pair with other application. That other application need to dynamically change DNS configuration data (some kind of dynamic DNS). What is "Active Directory Storage" - is it some kind of database or what? – Eye of Hell Jan 26 '10 at 12:22
Active Directory if where Windows server stores all the domain related information. – proy Jan 26 '10 at 13:04
I'd suggest that if your not aware of AD then its probabley not something you want to be trying to learn and experiment with in your application. – Sam Jan 26 '10 at 15:11
I'm perfectly aware of AD, but i'm unsure where it's STORAGE is located and what it's technically ^_^. – Eye of Hell Jan 26 '10 at 15:44
Ok, sorry, I read that wrong, see my update – Sam Jan 26 '10 at 16:02

You could use DNSCMD to change the zone somewhat safely without mucking in AD directly. I say "somewhat" because there be dragons in this land.

If you have your sword and armour, then changing AD can be done with LDIFDE, or directly with ADSI calls.

share|improve this answer

Microsoft DNS isn't what you want to use for something like this. Nor BIND for that matter.

There are lots of good DNS server libraries for many languages out there that support database back-ends. Usually they are focused on geolocation, like pgeodns.

share|improve this answer

I agree with everyone else, mucking with AD is not a good idea. If you want your application to interact (add, delete, etc.) with DNS zones\records on a Windows DNS server, use the dnscmd utility.

share|improve this answer

DNS Server using a SQL backend will just slow up DNS response time. Are you looking to get statistics of the DNS? If so then you need to look at the Windows Server SDK which will allow you to interrogate DNS, of course you will need experience in programming.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.