Using the Alias name instead of IP address/Host Name/Instance Name for accessing the SQL Server

When working on Support and Production DBA there is the possibility we need to access the multiple SQL Server Instance. Most of the time we will be using the IP address/Host Name/Instance Name. Just thought of checking whether the SQL Server is allowing us to use the Alias name instead of using the IP address. It would be very helpful and we can access the server with our own creative and easy accessible name.

Especially when you are in support (or) managing multiple server it would be easy to remember the Alias name instead of IP address.

Steps:

• Click on SQL Server Configuration Manager
• Then Click on Alias Name

• Right Click and add new Alias

 

• Enter the following info and click Ok.
• Alias Name (The Name you would like to keep for that IP address/Host Name/Instance Name)
• Post No (Default 1433) - (OR) Provide the Port number which used was used in Server.
• Protocol – TCP/IP
• Server – (It can be Actual IP address/Host Name/Instance Name)

• Now you can access the Database Server using the New Alias Name in SQL Server Management Studio.

Thanks & Regards,

Karthikeyan Jothi.

"You Never Fail Until You Stop Trying"