SQL2014 named-instance alias

Hello, this is in SQL2014 Standard. I am creating aliases for my existing DB connections ie "mydb.mydomain.com" and "mydb.mydomain.com\myInstance". They all point to the local server (SQL2014server) and port 1433. The former works fine but the latter (the one with the named instance) doesn't. Any ideas? Thanks
criskritAsked:
Who is Participating?
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Are you certain you provided the fixed port in the alias definition? I cannot test with an unnamed instance, but with named instances as target it works whenever the alias definition is correct.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How are you creating the aliases?
0
 
Eugene ZCommented:
do you have 2 sql servers instance on the same box?

if "yes" your 2nd named should have another port ( see port in "SQL Server Configuration Manager')
in this case you can use: Alias, port

for example: mydb.mydomain.com, 1435
0
 
criskritAuthor Commented:
Hi guys, thanks for the answers, this was my mistake, there was a space at the end of the alias definition in SQL Configuration. I removed the space and everything works now!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.