I will show you here a tool called "SQL Server Client Network Utility" (RUN > CliConfg.exe), With this tool we can create SQL Alias for our DB Server instead of the FQDN of the DB Server when we install SharePoint for example.
It makes life easier when we want to move to other SQL Server, just change the Alias on the WFE's and you ready to go, It's known as Best Practice for installing SharePoint.
More than that, when you configure the DB Alias in the utility you can specify pre-defined protocol so you get better performance for your clients !
It makes life easier when we want to move to other SQL Server, just change the Alias on the WFE's and you ready to go, It's known as Best Practice for installing SharePoint.
More than that, when you configure the DB Alias in the utility you can specify pre-defined protocol so you get better performance for your clients !
Refer to this great post about CliConfg.exe: Click Here
