Suppose I setup alias in sql configuration manager, then on the same server, via management studio I can use the alias name to connect to the server.

However, on another computer when I open management studio, then can I use the alias name to connect? My understanding is that the SQL server IP or server name can be used as that is recorded in the DNS. Can alias work and if yes, then how?

1 Answer 1


No, aliases are local to the client machine. Use DNS if you want a central configuration place.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.