Contents
Or you might need to move it to newer hardware. Renaming service application databases is often done to remove the GUID from the database name after you’ve used SharePoint Products Configuration Wizard and SharePoint Server Product Configuration Wizard to create the service application databases in your farm.
It’s actually a lot simpler than it probably should have been. SharePoint actually stores the connection to the configuration database in the registry (see dsn key ). SharePoint 2007: HKLM\\SOFTWARE\\Microsoft\\Shared Tools\\Web Server Extensions\\12.0\\Secure\\ConfigDB
How to change the database server in a SharePoint farm?
Open Registry Editor, and then verify that the ConnectionString value of the HKLM\\SOFTWARE\\Microsoft\\AppFabric\\V1.0\\Configuration key is updated. Here is an example: Repeat step 1 to 5 on each of the other servers in the Distributed Cache cluster.
If a previous version of the database that does not include the unsupported modifications is unavailable, or if the customer cannot roll back the database modifications, the customer must recover the data manually. The database must be restored to an unmodified state before Microsoft SharePoint Support can provide any data migration assistance.
Use an account that is a member of the Farm Administrators SharePoint group. In Central Administration click System Settings. On the System Settings page, in the Servers section, click Manage services on server. Find the service application that you want to stop, click Stop or Disable in the Action column for the service, and then click OK.
How to move or rename service applications in SharePoint?
Point the SharePoint service application to the moved or renamed database using either the SharePoint Central Administration website or PowerShell. Depending on how many service application databases you move or rename, pointing the service application to the database can be complex.