Hi i have a question about managing DNS records. Lets say i have a single server that contains an IIS server and an SQL server. A friend of mine has suggested that i have a single A record that points to that servers IP address and setup 2 CNAME records, sql.XXXX.XXX and www.XXXX.XXX.

I was wondering what the point is? couldnt someone access the SQL instance using www.XXXX.XXX and conversly access the IIS instance by using SQL.XXXX.XXX seeing as they point to the same server and IP?

If this is the case wouldnt it just be easier to have just everyone access via XXXX.XXX (no subdomain) and leave it at that?

3 Answers
3

The assumption here is that, at some point, the two server types may reside on different physical or virtual servers with (necessarily) two separate IP addresses. Separating the web and db servers is a pretty common setup. Using CNAMEs or separate A records lets you easily move one without having to add new DNS records.