Export (0) Print
Expand All

Rename the User Profile service application databases in SharePoint Server 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013

Topic Last Modified: 2014-01-30

Summary: Learn how to rename the User Profile service application databases in SharePoint Server 2013.

You typically rename service application databases to remove the GUID from the database name after the databases were created by the SharePoint Products Configuration Wizard, or to bring the databases into alignment with your organization's naming standards.

You can rename a User Profile service application database by using SQL Server tools.

ImportantImportant:
The steps in this article apply only to SharePoint Server 2013.

In this article:

NoteNote:
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

To rename a service application database, you must use SQL Server. To move a service application database, you must use SQL Server and Windows Explorer. We recommend that you stop the services related to the service application before you rename or move the related database. In general, we expect that you will either rename or move a database. That is, you will typically not perform both actions.

The instructions in this article assume that you have installed SQL Server Management Studio on the database server. If this is not the case, you can download and install Management Studio at Microsoft SQL Server 2008 R2 RTM Management Studio Express.

To stop the service application
  1. On the database servers on which the operations are performed, you must be a member of the following:

    • Administrators group on the local server

    • db_owner fixed database role

      In some environments, you must coordinate the rename procedures with the database administrator. Be sure to follow any applicable policies and guidelines for managing databases.

  2. For each service application that you plan to change the database for, you must stop the service or disable the service application by following the appropriate procedure for the service application that you are working with. For more information, see Start or stop a service (SharePoint 2013).

To rename a database by using SQL Server Management Studio
  1. In SQL Server Management Studio, connect to the source SQL Server instance, and then expand the Databases node.

  2. Right-click the database that you want to rename, click Rename, and then type the new name. Repeat this step for each database that you want to rename.

The only method for pointing a User Profile service application to a renamed database is to delete the service application and then re-create the service application. When you re-create the User Profile service application, use the new database name.

This method includes first documenting the User Profile service application settings and then deleting the service application. Next, re-create the User Profile service application and use the new database name. Finally, restart the service application.

To document service application settings
  1. Before you delete and re-create a service application, document the settings for the service application. To do this, use the recommended Windows PowerShell cmdlets that are described in the article Document farm configuration settings in SharePoint 2013.

To delete the service application by using Central Administration
  1. Verify that the user account that is performing this operation is a member of the Farm Administrators SharePoint group.

    NoteNote:
    Do not delete the User Profile service application database.
  2. On the the SharePoint Central Administration website, click Application Management, and then click Manage service applications.

  3. On the Manage service applications page, click the row that contains the User Profile service application that you want to delete. The ribbon becomes available.

  4. On the ribbon, click Delete.

  5. In the Delete Service Application dialog box, make sure that the check box next to Delete data associated with the Service Applications is not checked.

    NoteNote:
    If you check this box, it deletes the User Profile service application database.
  6. Click OK to delete the User Profile service application.

To re-create the service application
  1. Re-create the User Profile service application, pointing it to the renamed database, and reusing all the other initial configuration settings.

  2. Depending on the service application, you may have to manually start the related service.

To restart a service application
  1. In Central Administration, under System Settings, click Manage services on server.

  2. In the Service list, next to the User Profile, click Start.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft