How to give servers in the list of connections an alias
sql-server, ssms
Solution
Add an Alias in the SQL Client configuration you will be able to connect via the alias you give it. For example if you want to connect to 192.168.0.45 using the name Bertie set a new alias with and Alias Name of Bertie and a Server of 192.168.0.45 (don't worry about ports if you are using the defaults). Then in SSMS you can connect to Bertie
Problem
I am using SQL Server Management Studio 2012. When I want to connect to a server, the "Connect to Server" dialogue box appears. In that dialogue, there's a drop down list of all the possible servers. I have lots of different IP addresses dependant on which server I want to connect to... Is there any way of giving these IP addresses an alias ? eg. instead of 219.115.213.81 I could have "My test DB" Thanks, Scott