How to Promote a Secondary Management Server in a Lab Environment
Updated: May 13, 2016
Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager
Use the following procedure to promote the secondary management server.
To promote the secondary management server
On the secondary management server, do the following:
Close the Service Manager console.
On the Windows desktop, click Start, and then click Run.
In the Run dialog box, in the Open text field, type services.msc, and then click OK.
In the Services window, in the Services (Local) pane, locate the following three services and for each one, click Stop:
System Center Data Access Service
System Center Management
System Center Management Configuration
Leave the Services window open.
Open Windows Explorer. Locate the \Program Files\Microsoft System Center\Service Manager 2010 folder.
In this folder, delete the Health Service State folder and all of its contents.
Do the following on the ServiceManager database on the Test SQL Server instance:
On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
In the Connect to Database Engine dialog box, follow these steps:
In the Server name box, type the name of the server that hosts the ServiceManager database.
In the Authentication box, select Windows Authentication.
Click Connect.
In the Object Explorer pane, expand Databases, and then click ServiceManager.
On the toolbar, click New Query.
In the SQLQuery1.sql pane (center pane), type the following, where <FQDN of your server> is the FQDN of the management server that you are promoting:
EXEC p_PromoteActiveWorkflowServer '<FQDN of your server>'
On the toolbar, click Execute.
At the bottom of the SQLQuery1.sql pane (center pane), observe that Query executed successfully is displayed.
Exit Microsoft SQL Server Management Studio.
Do the following on the secondary management server:
On the Windows desktop, click Start, and then click Run.
In the Run dialog box, in the Open field, type services.msc, and then click OK.
In the Services window, in the Services (Local) pane, locate the following three services and for each one, click Start.
System Center Data Access Service
System Center Management
System Center Management Configuration
Your secondary management server is now the primary management server for the management group.