Aliasing Sql Server

To give an alias name to your Sql Server, follow the below steps:

1. Login to the machine/server (typically a WFE) from where you want to access the SQL server             using its alias name.
2. Go to C:\Windows\System32 and locate and double click on "cliconfg"
3. "SQL Server Client Network Utility" window opens as shown below

4. Go to "Alias" tab, click "Add"
5. Enter "Server alias" name (SqlServer01)
6. Under "Network alias",  Select "TCP/IP"
7. Under "Connection Parameters", enter Server Name (actual Sql Server name - SPSQL01) and click     "OK"

8. You should see the alias has created as shown below

9. Do PING <aliasname> from command prompt and confirm the alias is created successfully.