Can I point a CNAME at a specific instance within a SQL server? Not just the server itself

I am working with a database admin. She needs me to create a CNAME on our DNS server that points to a specific "instance" on a SQL server. I created a basic CNAME and pointed it at the server where SQL is installed but it right now she sees it as pointing to the default instance. I am not a SQL person, but is there a way for me to create a CNAME or even a HOST entry and point it to a specific instance within a SQL server? Not just the server itself? We are using Windows 2012 and SQL 2012.
LVL 1
Thor2923Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Travis MartinezStorage EngineerCommented:
I had help finding this:

https://blogs.msdn.microsoft.com/dbrowne/2012/05/21/how-to-add-a-hostname-alias-for-a-sql-server-instance/

The short answer is no, not directly.  The much longer answer as the link describes above is configuring the SQL instance to listen on a specific port, 1443 for the IP address given.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
No. The way to point to a specific SQL Server instance is ServerName\InstanceName or ServerName,portNumber.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott PletcherSenior DBACommented:
I think you can point the CNAME to the specific IP address of the instance, but I am not a networking person and do not claim any addressing expertise.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Vitor MontalvãoMSSQL Senior EngineerCommented:
@Scott: The problem is that you can have more than one SQL Server instance on an IP address. The question is how to solve that issue with a CNAME.
0
Scott PletcherSenior DBACommented:
@Vitor:

Interesting.  Maybe it's just the port that has to be different.  As I said, I'm not an expert in that area.

I know at one place they assigned unique addresses, but that was probably just their preference.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
That was my understanding:
"(...)is there a way for me to create a CNAME or even a HOST entry and point it to a specific instance within a SQL server?"
0
nociSoftware EngineerCommented:
DNS (CNAME, A, AAAA etc.) is a translatoin service for humans to translate a host/domain name into an IP address.
IP connections only can be done on Ipaddres/port pairs, something that is hard for humans to handle in large amounts.

As there is NO connections between DNS and database content a change of CNAME will not help.
(For webservers it is slightly different, as a webserver is told the name afterward inside the query, something that not a lot of protocols do regularly).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.