I recently had a problem to create a SQL Server alias and tried many things to solve it. Here is my complete solution if you want to enable SQL Server:
-
Open SQL Server Configuration Manager. If you cannot find it in the Windows application menu, run this command:
C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager12.mscNote that the number 12 could be different based on your SQL Server version. -
Browse to the SQL Native Client X.xx Configuration section where X.xx is your SQL Server version. Add the alias with required name as shown in the picture below:
-
Make sure that the SQL following Server services are running: SQL Server, SQL Server Browser, SQL Server Agent as below:
-
Here is the trick to make sure that it is running, open SQL Server Client Network utility by open the Windows Command run and type
CLICONFG. -
In general tab, enable the TCP/IP and named pipes protocols as following picture:
-
In alias tab, add the required alias as following:
Enjoy SQL Server Alias!