Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Rename the SharePoint Translation Services service application databases in SharePoint Server 2013

SharePoint 2013

Published: July 16, 2012

Summary: Learn how to rename the SharePoint Translation Services service application databases in SharePoint Server 2013.

Applies to:  SharePoint Server 2013 

Renaming service application databases is typically done to remove the GUID from the database name after the databases have been created by the SharePoint Products Configuration Wizard, or to bring the databases into alignment with your organization's naming standards.

You can use the SharePoint Central Administration website and SQL Server tools to stop the service, rename the databases, and then point to the renamed databases.

Important Important:

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

In this article:

Before you begin

The general process for renaming or moving service application databases is as follows:

  1. Rename the database by using SQL Server tools.

  2. Point the service application to the renamed database.

note Note:

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:

Important Important:

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.

Rename the service application databases by using SQL Server

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. Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.

  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 the databases 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.

Point the service application to a renamed or moved database

You can point the SharePoint Translation Services service application to a renamed or moved database by using Central Administration.

To point the SharePoint Translation service application to a renamed or moved database by using Central Administration

  1. Verify that the user account that is performing the procedure is a member of the Farm Administrators SharePoint group.

  2. In Central Administration, click Application Management, and then, click Manage service applications.

  3. On the Service Applications page, place your cursor next to SharePoint Translation Services and then click the empty row.

    The ribbon becomes active.

  4. In the Operations group of the ribbon, click Properties.

    The Edit SharePoint Translation Services Application page appears.

  5. Change the database name, and then click OK.

    note Note:

    If you use an incorrect database name, SharePoint Server 2013 creates a new database.

  6. In the Quick Launch, click System Settings.

  7. On the System Settings page, in the Servers section, click Manage services on server.

  8. In the Service list, next to the SharePoint Translation Services, click Start.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.