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?