Installing workflow manager on sharepoint 2016

Scenario:
Sharepoint 2016 needs workflow supports since 2010 workflows now seems dead.
This needs to be done offline

Overview of steps

1. Download all programs from internet-enabled client with getOfflinePackages
2. Install packages on server in correct order
3.  Configure workflow manager
4.  Register workflow service in sharepoint

Step 1 - Download necessary files for offlineinstallationen

On client with webaccess

1. Install WebPlattformInstaller
2. Download packages with getOfflinePackages.ps1

	$products = "ServiceBus,ServiceBusCU1,WorkflowCU4,WorkflowManagerRefresh,WorkflowClientCU4"
	$scriptPath = $(split-path -Parent $MyInvocation.MyCommand.Definition)
	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/offline /products:$($products) /path:$scriptPath\WebPlattFormFiles" -NoNewWindow -PassThru -wait

view raw getOfflinePackages.ps1 hosted with ❤ by GitHub

Step 2 - Install packages on server in correct order

1. Install packages with InstallWFM.ps1 to get correct order
   

   	$scriptPath = $(split-path -Parent $myinvocation.MyCommand.Definition)
   	#1 servicebus
   	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/install /products:ServiceBus /xml:$($scriptPath)\WebPlattFormFiles\feeds\latest\webproductlist.xml /AcceptEula /suppressPostFinish" -wait -passthru
   	#2 service bus updates
   	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/install /products:ServiceBusCU1 /xml:$($scriptPath)\WebPlattFormFiles\feeds\latest\webproductlist.xml /AcceptEula /suppressPostFinish"
   	#3 workflowmanager client
   	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/install /products:WorkflowClientCU4 /xml:$($scriptPath)\WebPlattFormFiles\feeds\latest\webproductlist.xml /AcceptEula /suppressPostFinish"
   	#4 workflowmanagerrefresh
   	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/install /products:WorkflowManagerRefresh /xml:$($scriptPath)\WebPlattFormFiles\installers\WorkflowManagerRefresh\feeds\latest\webproductlist.xml /AcceptEula /suppressPostFinish"
   	#5 workflowmanager updates
   	start-process -FilePath 'C:\Program Files\Microsoft\Web Platform Installer\webpicmd.exe' -ArgumentList "/install /products:WorkflowCU4 /xml:$($scriptPath)\WebPlattFormFiles\feeds\latest\webproductlist.xml /AcceptEula /suppressPostFinish"

   view raw InstallWfm.ps1 hosted with ❤ by GitHub

Step 3 - Configure Workflow Manager

1. Update wfmconfig.xml with credentials and databasename
2. Configure with configureWFM.ps1
   

   	function WFM-Configure {
   	param (
   	$dbServer,
   	$dbPrefix,
   	$spServiceAcctName,
   	$spServiceAcctPwd,
   	$spAdminAcct,
   	$passphrase
   	)
   	# Create new SB Farm
   	$SBCertificateAutoGenerationKey = ConvertTo-SecureString -AsPlainText -Force -String $passphrase;
   	$WFCertAutoGenerationKey = ConvertTo-SecureString -AsPlainText -Force -String $passphrase;
   	$managementCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_Management;Integrated Security=True;Encrypt=False';
   	$gatewayCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_Gateway;Integrated Security=True;Encrypt=False';
   	$messageContCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFMSB_MessageContainer;Integrated Security=True;Encrypt=False';
   	Write-Host -ForegroundColor White ' - Creating new Service Bus farm...' -NoNewline;
   	try {
   	$sbFarm = Get-SBFarm -SBFarmDBConnectionString $managementCS;
   	Write-Host -ForegroundColor White 'Already Exists';
   	}
   	catch {
   	New-SBFarm -SBFarmDBConnectionString $managementCS -InternalPortRangeStart 9000 -TcpPort 9354 -MessageBrokerPort 9356 -RunAsAccount $spServiceAcctName -AdminGroup 'BUILTIN\Administrators' -GatewayDBConnectionString $gatewayCS -CertificateAutoGenerationKey $SBCertificateAutoGenerationKey -MessageContainerDBConnectionString $messageContCS;
   	Write-Host -ForegroundColor White 'Done';
   	}
   	# Create new WF Farm
   	Write-Host -ForegroundColor white " - Creating new Workflow Farm..." -NoNewline;
   	$wfManagementCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_Management;Integrated Security=True;Encrypt=False';
   	$wfInstanceCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_InstanceManagement;Integrated Security=True;Encrypt=False';
   	$wfResourceCS = 'Data Source=' + $dbServer + ';Initial Catalog=' + $dbPrefix + '_WFM_ResourceManagement;Integrated Security=True;Encrypt=False';
   	try {
   	$wfFarm = Get-WFFarm -WFFarmDBConnectionString $wfManagementCS;
   	Write-Host -ForegroundColor White 'Already Exists';
   	}
   	catch {
   	New-WFFarm -WFFarmDBConnectionString $wfManagementCS -RunAsAccount $spServiceAcctName -AdminGroup 'BUILTIN\Administrators' -HttpsPort 12290 -HttpPort 12291 -InstanceDBConnectionString $wfInstanceCS -ResourceDBConnectionString $wfResourceCS -CertificateAutoGenerationKey $WFCertAutoGenerationKey; #changed admingroup
   	Write-Host -ForegroundColor white 'Done';
   	}
   	# Add SB Host
   	Write-Host -ForegroundColor white ' - Adding Service Bus host...' -NoNewline;
   	try {
   	$SBRunAsPassword = ConvertTo-SecureString -AsPlainText -Force -String $spServiceAcctPwd;
   	#Add-SBHost -SBFarmDBConnectionString $managementCS -RunAsPassword $SBRunAsPassword -EnableHttpPort -EnableFirewallRules $true -CertificateAutoGenerationKey $SBCertificateAutoGenerationKey; #removed enablehttpport
   	Add-SBHost -SBFarmDBConnectionString $managementCS -RunAsPassword $SBRunAsPassword -EnableFirewallRules $true -CertificateAutoGenerationKey $SBCertificateAutoGenerationKey;
   	Write-Host -ForegroundColor white 'Done';
   	}
   	catch {
   	Write-Host -ForegroundColor white 'Already Exists';
   	#write-warning "Error was $($_.exception)"
   	}
   	Write-Host -ForegroundColor white ' - Creating Workflow Default Namespace...' -NoNewline;
   	$sbNamespace = $dbPrefix + '-WorkflowNamespace';
   	try {
   	$defaultNS = Get-SBNamespace -Name $sbNamespace -ErrorAction SilentlyContinue;
   	Write-Host -ForegroundColor white 'Already Exists';
   	}
   	catch {
   	try {
   	# Create new SB Namespace
   	$currentUser = $env:userdomain + '\' + $env:username;
   	#New-SBNamespace -Name $sbNamespace -AddressingScheme 'Path' -ManageUsers $spServiceAcctName,$spAdminAcctName,$currentUser; #replaced spAdminAcctName with spadminAcct
   	New-SBNamespace -Name $sbNamespace -AddressingScheme 'Path' -ManageUsers $spServiceAcctName,$spAdminAcct,$currentUser;
   	Start-Sleep -s 90
   	Write-Host -ForegroundColor white 'Done';
   	}
   	catch [system.InvalidOperationException] {
   	throw;
   	}
   	}
   	# Get SB Client Configuration
   	$SBClientConfiguration = Get-SBClientConfiguration -Namespaces $sbNamespace;
   	# Add WF Host
   	try {
   	$WFRunAsPassword = ConvertTo-SecureString -AsPlainText -Force -String $spServiceAcctPwd;
   	Write-Host -ForegroundColor White ' - Adding Workflow Host...' -NoNewline;
   	Add-WFHost -WFFarmDBConnectionString $wfManagementCS `
   	-RunAsPassword $WFRunAsPassword -EnableFirewallRules $true `
   	-SBClientConfiguration $SBClientConfiguration -CertificateAutoGenerationKey $WFCertAutoGenerationKey;
   	Write-Host -ForegroundColor White 'Done';
   	}
   	catch {
   	Write-Host -ForegroundColor white "Already Exists";
   	}
   	}
   	Import-Module WorkflowManager -ErrorAction SilentlyContinue
   	$scriptPath = $(split-path -Parent $myinvocation.MyCommand.Definition)
   	[xml]$wmfConfig = get-content -Path "$scriptPath\wfmConfig.xml"
   	WFM-Configure -dbServer $wmfConfig.configuration.dbserver -dbPrefix $wmfConfig.configuration.dbprefix -spServiceAcctName $wmfConfig.configuration.spServiceAcctName -spServiceAcctPwd $wmfConfig.configuration.spServiceAcctPwd -spAdminAcct $wmfConfig.configuration.spAdminAcct -passphrase $wmfConfig.configuration.passphrase

   view raw configureWfm.ps1 hosted with ❤ by GitHub

   	<configuration>
   	<dbserver>sp2016</dbserver>
   	<dbprefix>WFM</dbprefix>
   	<spServiceAcctName>mycompany\workflowaccount</spServiceAcctName>
   	<spServiceAcctPwd>mypassword</spServiceAcctPwd>
   	<spAdminAcct>mycompany\spinstall</spAdminAcct>
   	<passphrase>mypassphrase</passphrase>
   	</configuration>

   view raw wfconfig.xml hosted with ❤ by GitHub
3. Update siteaddress and run registerWFOnsite
   

   	Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue
   	Import-Module WorkflowManager -ErrorAction SilentlyContinue
   	Register-SPWorkflowService -SPSite "https://site.mycompany.com" -WorkflowHostUri "https://site.mycompany.com:12290"
   	$wms = Get-SPWorkflowServiceApplicationProxy
   	$wms.RegisterWorkflowLifecycleManagementEnvironment()

   view raw gistfile1.txt hosted with ❤ by GitHub

References:
https://www.helloitsliam.com/2014/11/06/sharepoint-2013-workflow-manager-woes/ - source for the order of installation
http://blog.robgarrett.com/2014/05/12/install-workflow-manager-with-powershell/ - original script for configuring workflow manager

https://blogs.msdn.microsoft.com/laleh/2014/09/03/sharepoint-2013-workflow-troublehsooting/ - troubleshooting workflow manager
https://social.technet.microsoft.com/wiki/contents/articles/34407.sharepoint-2016-step-by-step-installation-of-workflow-manager.aspx - another installationguide
https://knowledge.zomers.eu/SharePoint/Pages/How-to-install-and-configure-Workflow-Manager-on-Windows-2012-R2.aspx - more updated information on how to configure worklow manager
https://docs.microsoft.com/en-us/iis/install/web-platform-installer/web-platform-installer-direct-downloads - webplattforminstaller