If we need to setup SQL server alias, Please follow the below steps.
- Run the 32-bit SQL tool. Run the following application, “C:\windows\system32\cliconfg.exe”
- Select the tab “Alias” and click the button “Add”.
- Select “TCP/IP” and define your alias. Next, fill in the original server name of your database server and select the “Dynamically determine port” checkbox. After that click “OK”.
- Now you have defined your SQL alias name. Click “OK”.