Rename SharePoint 2010 application and SQL server names

Hi, we're going through a server renaming process at the moment and the time has come where i need to change the application and database server names for SharePoint 2010 (running Project Server 2010).

I've seen multiple blogs, each saying it's very tricky and can go horribly wrong. But then others saying it's just a case of renaming the SQL aliases and running an STS command.

Is anyone able to tell me in simple terms what process i should follow?

Many thanks
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohit NairSenior AssociateCommented:
Best thing is if you remember your SharePoint farm passphrase its simple. Disconnect all the SharePoint server from the farm and rename all the server names. Once all reboot is done, reconnect the server back to SharePoint. Use products and technologies wizard to do all this. Please keep good backup of the farm and DR if you have it before performing this activity.
Treat it as though you are moving the database to a new server rather than renaming a SQL server instance (in fact if you want keep a full DR option available then this is exactly what you should do anyway to allow you to go back to where you were if it all goes wrong).  Here is the official guide to moving to a new SQL backend server:

I would recomend that you first backup the entire farm, build a new server and install SQL and test that etc., then follow the guide above to move SharePoint DBs to the new server.  Once fully commisioned you can decommision the old SQL server.

Once done, check the ULS logs for authentication errors in the backed services (there always seem to be some!).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jayaraja JayaramanSharepoint Architect ConsultantCommented:
backup the current database and restore it with a new database name.
then add the database in the content database for the webapplication/site collection .
lastly remove the old database reference from the manage content databases.
Justin SmithSr. System EngineerCommented:
Mohit's recommendation is valid for renaming the SharePoint server.  

For SQL, the easiest thing to do is create a SQL Alias.  Do this from all SharePoint servers.  Then Alias name should be the name of the current SQL Server, and it should point to the current SQL Server.  Once you rename the SQL Server you'll update the Alias to point to the new name.  Don't change the Alias name, just the server it points to.

Another thing to think about is your web applications.  If any of them use the server name for their URL you'll need to update that too.  Renaming a Default Zone URL has steps.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.