Orchestrator Designer generates a prompt for a license key after you migrate the Orchestrator database

Article translations Article translations
Article ID: 2920037 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you migrate the Orchestrator database from one instance of Microsoft SQL Server to another and then try to open Orchestrator Designer in Microsoft System Center 2012 Orchestrator or in System Center 2012 R2 Orchestrator, Orchestrator Designer starts to open and then generates a prompt that indicates that the license key expired. When you enter a valid key and then click OK, the same prompt appears.

Cause

When you migrate the Orchestrator database from one instance of Microsoft SQL Server to another, the service master key (SMK) must also be backed up. This database key must then be reapplied on the new instance of SQL Server after the database is restored. If the SMK is not backed up on the original server, you must re-create the SMK on the new server.

Resolution

To resolve this issue, follow these steps:
  1. Stop the Orchestrator Management service.
  2. Open the Orchestrator database on the new instance of SQL Server.
  3. Open a new query, and make sure that the Orchestrator database is selected.
  4. Execute the following two lines on the database, one at a time:
    1. Delete the old key:

      [Microsoft.SystemCenter.Orchestrator.Cryptography].[DropOrchestratorKeys]
    2. Create the new key:

      [Microsoft.SystemCenter.Orchestrator.Cryptography].[CreateOrchestratorKeys]
  5. Start the Orchestrator Management service.
When you now open Orchestrator Designer, you are again prompted for the key. When you enter the key, the key works as designed.

More information

When the Orchestrator database SMK is lost, encrypted data is also lost. Variables that were set up with an encrypted password, for example, will no longer have values and must be repopulated. For more information about how to correctly migrate the Orchestrator database to a new server, go to the following Microsoft TechNet website:
Migrate Orchestrator Between Environments

Properties

Article ID: 2920037 - Last Review: December 26, 2013 - Revision: 1.0
Applies to
  • Microsoft System Center 2012 Orchestrator
  • Microsoft System Center 2012 Orchestrator Service Pack 1
  • Microsoft System Center 2012 R2 Orchestrator
Keywords: 
KB2920037

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com