Scenario– Promote secondary Management Server to Workflow server.  In this case I needed
to promote my DEV server (which was originally a secondary management server in
Prod moved to DEV).

Environment– Server 2012 nonR2, Service Manager 2012 Sp1 UR4, Remote SQL 2012 Sp1

Guide

There are several scenarios why you would change the Management server that performs the workflows, my reason came into play when attempting to upgrade my DEV environment to R2.

Here is the error I received when attempting to Upgrade to R2

“The management server which is currently designated to run the workflows must be upgraded before this management server can be upgraded.”

figure 1

First log onto the Management server you wish to promote and kill the following services

System Center Data Access Service

System Center Management

System Center Management Configuration

figure 2

Now delete \Program Files\Microsoft System Center 2012\Service Manager\Health Service State

figure 3

Connect to your database server if its remote, or open SQL Management Studio and select the “ServiceManager” database.

In the SQLQuery1.sql pane (the center pane), type the following, where <FQDN of your server> is the fully qualified domain name (FQDN) of the management server that you are promoting:

EXEC p_PromoteActiveWorkflowServer ‘<FQDN of your server>’

figure 4

Reboot management server or start the services you stopped earlier-

System Center Data Access Service

System Center Management

System Center Management Configuration

Here is the MS official guide for SCSM 2012+

http://technet.microsoft.com/en-us/library/hh524221.aspx

-End of line