Team blog of MCS @ Middle East and Africa

This blog is created by Microsoft MEA HQ near shoring team, and it aims to share knowledge with the IT community.With its infrastructure and development sides,It brings to you the proven best practices and real world experiences from Subject Matter Experts
Follow Us On Twitter! Subscribe To Our Blog! Contact Us

Creating a SQL Server alias using the SQL Server Client Network Utility

Creating a SQL Server alias using the SQL Server Client Network Utility

  • Comments 2
  • Likes

Many think that you have to install the SQL Server client tools to be able to create a SQL Server alias on a client machine. You can do this without installing SQL Server client tools. Windows ships with the SQL Server Client Network Utility. This is all what you need to create an alias. Click run and type cliconfg.exe and you will get the utility. Enable a protocol - e.g. TCP/IP

Click on the Alias tab and click on Add...

Add an alias as the below figure depicts.

Enjoy!

 

 

Comments
  • Sweet

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment