0

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?

grigoryvp
  • 3,655
  • 11
  • 39
  • 59

5 Answers5

5

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.

Sam Cogan
  • 38,736
  • 6
  • 78
  • 114
  • 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? – grigoryvp Jan 26 '10 at 12:22
  • 4
    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 Cogan 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 ^_^. – grigoryvp Jan 26 '10 at 15:44
  • Ok, sorry, I read that wrong, see my update – Sam Cogan Jan 26 '10 at 16:02
2

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.

JamesR
  • 1,061
  • 5
  • 6
1

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.

rmalayter
  • 3,762
  • 20
  • 28
0

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.

joeqwerty
  • 109,901
  • 6
  • 81
  • 172
0

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.

Saif Khan
  • 1,945
  • 2
  • 20
  • 25