SQL Server Alias setup in the client setup and NOT the server setup. It took sometime to understand the fact. The other thing that tricked me was 32-bit and 64-bit version of the tool, cliconfg.exe. It depends on the application you are trying to setup the alias for - meaning, if the application is 32-bit use c:\Windows\SysWOW64\cliconfg.exe and if it is 64-bit application just use normal cliconfg.exe (assuming that you are in 64-bit machine).
cliconfg.exe is a Windows OS tool and therefore does not need additional installs.
1. Run the application, either from c:\Windows\SysWOW64\cliconfg.exe (for 32-bit)
or c:\Windows\System32\cliconfg.exe or just press windows + r and type cliconfg and hit enter (for 64- bit)
2. In SQL Server Client Network Utility window > General tab, enable TCP/IP (or desired protocol)
3. In Alias tab, click Add
4. In Edit Network Library Configuration window, give in Server alias, Server Name, and Server name
5. Click OK
6. Click OK
astu...
