Reset Certificate Generation Key for WorkFlowManager and ServiceBus

We might face a scenario of removing a node from existing workflow manager(WFM) farm and add it back during troubleshooting with WFM farm or Service Bus(SB) farm.

In those scenarios, we might lose/forget the Certificate Generation key which is mandatory to be entered while we select the option of "Join to an Existing Workflow Manager Farm". We have also seen engineers rebuilding the farm considering this as a road blocker to join the node back to existing farm.

blog121-01

We need to reset this Certificate Generation Key for WFM and SB separately following below steps.

Reset Certificate Generation Key for WFM using WFM PowerShell:

Note: "WFM$amplepwd1" is the new key we are going to set.

$CertKey=convertto-securestring "WFM$amplepwd1" -asplaintext -force

Set-WFCertificateAutoGenerationKey  -WFFarmDBConnectionString 'Data Source=lmc-vsqlp06;Initial Catalog=WFManagementDB;Integrated Security=True;Encrypt=False' -key $CertKey -Verbose

blog121-02

 

-Update SB CertificateAutoGenerationKey

 

$mycert=ConvertTo-SecureString -string LMCSharepointProd1 -force -AsPlainText

Set-SBCertificateAutogenerationKey -SBFarmDBConnectionString 'Data Source=lmc-vsqlp06;Initial Catalog=SBManagementDB;Integrated Security=True;Encrypt=False' -key $mycert -Verbose

blog121-03

-Now provide the new Certificate Generation Key (WFM$amplepwd1 in our case) in WFM configuration wizard (and SB configuration wizard) which should accept your new key

blog121-04

-All services started running. To apply the changes, we ran 3 more commands

Stop-Sbfarm

Update-SBfarm

Start-SBfarm

Written By
Sandeepkumar Pasumarthy
Microsoft GTSC

Comments

  • Anonymous
    June 19, 2017
    Thanks for article. Unfortunately having some issues running the commands. Is the "-Update SB CertificateAutoGenerationKey" correct?
    • Anonymous
      September 18, 2017
      Hi Dave, could you share the error message?
  • Anonymous
    October 25, 2017
    i am getting command issues also. I am get "Cannot validate argument on parameter 'WFFarmDBConnectionString'." Failure in connecting to SQL server.