Rename SharePoint 2010 application and SQL server names

Posted on 2014-08-26
Last Modified: 2014-12-11
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
Question by:afl_it
    LVL 9

    Expert Comment

    by:Mohit Nair
    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.
    LVL 15

    Accepted Solution

    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!).
    LVL 8

    Expert Comment

    by:Jayaraja Jayaraman
    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.
    LVL 38

    Expert Comment

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now