• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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
1 Solution
Mohit NairCommented:
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!).
Jayaraja JayaramanCommented:
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.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now