How to Set up an SQL Server Alias Name
May 15, 2018
A few notes on how to configure a SQL Server alias name for connecting through to a SQL server. Firstly you typically configure the alias in the client side, not server side.
I’d recommend that you install SQL Server Native Client on your client side and configure an alias. You can download SQL Server Native client at;
SQL Native Client for SQL 2005
SQL Native Client for SQL 2008 SP3
SQL Native Client for SQL 2008 R2
SQL Native Client for SQL 2012
Follow the steps to configure an alias on your client machine:
1. Run “cliconfg.exe” from windows run dialog
2. Click “Alias”
3. Click “Add…” to add a new alias
The following link maybe helpful:
http://blogs.msdn.com/wwepmcoe/archive/2010/01/07/sql-server-alias-names.aspx
SHARE THIS POST:
