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?

[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.

Qlemo"Batchelor", 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

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
How are you creating the aliases?
0
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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
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
Microsoft SQL Server

From novice to tech pro — start learning today.