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?
Your suggestion much appreciated.