Normally we have to install SQL client tool to create SQL
Server alias on the SharePoint Servers and Now you can create a SQL server
alias without installing SQL server client connectivity tool using SQL server
client network utility tool.
Steps:
a.
Start-> Run-> cliconfg.exe and it will
open SQL server Client network utility tool
Click Alias and Click add for creating SQL
server alias and Give the SQL alias name, Select TCP/IP and port no and click
ok. Now we have successfully created the SQL server alias.
