My client has asked me to move all the Database used by the SharePoint Farm to a new SQL Server Machine. I came across this article <http://technet.microsoft.com/en-us/library/cc512725(v=office.14).aspx> (Move All Databases) in Microsoft Technet.

Have anyone tried the steps mentioned in this article and came across any issues?

For setting up SQL Server Connection Alias <http://technet.microsoft.com/en-us/library/cc512725(v=office.14).aspx#Alias> Do I need to run the SQL Server configuration manager on SQL Server Mahcine or Do I need to use CLICONFG.EXE on the Application Server(Central Admin machine)? 

Someone has mentioned in this <http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx> article (go to the bottom of the article) that we should use CLICONFG.exe on the Application Server and the terminology "SQL Server Configuration Manager" is bit confusing.

```
Could someone verify if this SQL Alias settings will work?

```

![enter image description here](https://i.stack.imgur.com/thjYG.png)

Your suggestion much appreciated.