Roger Haueter

Modern Workplace Strategist | Microsoft Most Valuable Professional

Part 2: Configuring Workflow Manager for SharePoint 2013

Part 1: Installing Workflow Manager for SharePoint Server 2013 (offline)
Part 2: Configuring Workflow Manager for SharePoint 2013

 
As mentioned in my previous post additional software is needed to create SharePoint 2013 workflows in a SharePoint Server 2013 farm.
In this article I'll explain how to configure the Workflow Manager to use it with SharePoint Server 2013.

Make sure you already installed the Workflow Manager on your SharePoint server(s) as described here.

 

Workflow Manager Configuration

Run the Workflow Manager Configuration Wizard from the Start Menu on (one of) the SharePoint server(s)
Choose Configure Workflow Manager with Custom Settings
2013-10-11_163118

 
Configure Farm Management Database

  • SQL Server Instance: Enter the name of your database instance or your SQL Alias
  • Under Advanced Options check the box Use the above SQL Server instance and settings for all databases
  • Database name: Specify the name of the Workflow Management database

2014-11-19_101746_1

 
Configure Instance Management Database

  • SQL Server Instance: Is already set because you checked the box Use the above SQL Server instance and settings for all databases in step 1.
  • Database name: Specify the name of the Instance Management database

2014-11-19_101746_2

 
Configure Resource Management Database

  • SQL Server Instance: Is already set because you checked the box Use the above SQL Server instance and settings for all databases in step 1.
  • Database name: Specify the name of the Resource Management database

2014-11-19_101746_3

 
Configure Service Account

  • User ID: Specify a dedicated service account. This account does not have any rights in your SharePoint farm.
  • Password: Enter the password

2014-11-19_101746_4

 
Configure Certificates

  • Auto-generate: Uncheck the box Auto-generate certificates to use your own and trusted Wildcard certificate.
  • Services SSL Certificate: Select your Wildcard certificate for the corresponding domain name
  • Workflow Manager Outbound signing Certificate: Select your Wildcard certificate for the corresponding domain name
  • Encryption Certificate: Select your Wildcard certificate for the corresponding domain name

2014-11-19_101746_5

 
Configure Ports

  • Workflow Manager Management Port: Set port 12290 to use an SSL encyrpted connection
  • HTTP Port: Even if you don't want to allow unsecured connections you have to set a port. Enter 12291.
  • Uncheck the box Allow Workflow management over HTTP on this computer to use to use secured connections only.
  • Check the box Enable firewall rules on this computer

2014-11-19_101746_6

 
Configure Admin Group

  • Specify a group for managing the Workflow Manager farm.

2014-11-19_101746_7

 

Service Bus Configuration

Configure Farm Management Database

  • SQL Server Instance: Is already set because you checked the box Use the above SQL Server instance and settings for all databases in step 1 during the Workflow Manager Configuration.
  • Database name: Specify the name of the Farm Management database

2014-11-19_102524_1

 
Configure Gateway Database

  • SQL Server Instance: Is already set because you checked the box Use the above SQL Server instance and settings for all databases in step 1 during the Workflow Manager Configuration.
  • Database name: Specify the name of the Gateway database

2014-11-19_102524_2

 
Configure Message Container Database

  • SQL Server Instance: Is already set because you checked the box Use the above SQL Server instance and settings for all databases in step 1 during the Workflow Manager Configuration.
  • Database name: Specify the name of the Message Container database

2014-11-19_102524_3

 
Configure Service Account

  • Check the box Use the same service account credentials as provided for Workflow Manager (despite you want to use a dedicated service account for your Service Bus farm).

2014-11-19_102524_4

 
Configure Certificates

  • Uncheck the box Auto-generate certificates to use your own and trusted Wildcard certificate.
  • Farm Certificate: Select your Wildcard certificate for the corresponding domain name
  • Encryption Certificate: Select your Wildcard certificate for the corresponding domain name

2014-11-19_102524_5

 
Configure Ports

  • HTTPS Port: Use standard port 9355 or set your own port.
  • TCP Port: Use standard port 9354 or set your own port.
  • Message Broker Port: Use standard port 9356 or set your own port.
  • Internal Communication Port Range: Use standard ports 9000-9004 or set your own port range.

2014-11-19_102524_6

 
Configure Admin Group

  • Specify a group for managing the Service Bus farm.

2014-11-19_102524_7

 

Start the configuration process>/h2>
Verify your settings on Summary page. Click the link Get PowerShell commands on the bottom of this page to export your configuration settings as a PowerShell script.
Hit the right arrow to start the configuration process.
2013-10-11_170323

The wizard may take up to 10 minutes to complete.

2013-10-11_170324

 

Create a Workflow Manager Service Application

From the Start menu run the SharePoint Management Shell as administrator and execute the following command:
Register-SPWorkflowService -SPSite "https://sitecollection.yourdomain.com" -WorkflowHostUri "https://workflowservername.domain.com:12290"

 

Test the Workflow Manager

To test if the Workflow Manager Service Application has been created execute the following command:
Get-SPWorkflowServiceApplicationProxy

or verify it by browsing to SharePoint Central Administration > Application Management > Manage Service Applications
2013-10-14_111245

Open the SharePoint Designer  and click Open Site and enter the URL of your Site Collection (in this example: http://sitecollection.domain.com).
Go to the column Site Objects on the left side and click Workflows.
In the Ribbon click on Site Workflow.
2013-10-14_124905

A new window opens.
If you can select SharePoint 2013 Workflow as Platform Type the Workflow Manager is working fine. Otherwise please double check your settings.
2013-10-14_124906

 

Workflow Manager Client

To make the Workflow 2013 engine available to all servers in your SharePoint farm you have to install the Workflow Client on every SharePoint server.
The binaries are located in the folder with your extracted Workflow installer files:
C:\Temp\WorkflowManager\installers\WorkflowClient\183D2A27A8C3F8A261B7B8EC930EC7005D0E9FC3\WorkflowManagerClient_x64.msi


Part 1: Installing Workflow Manager for SharePoint Server 2013 (offline)

Part 1: Installing Workflow Manager for SharePoint Server 2013 (offline install)
Part 2: Configuring Workflow Manager for SharePoint 2013

 
With a common SharePoint Server 2013 installation you will be able to create workflows. But be careful, you are using the SharePoint 2010 workflow engine which will likely be not supported in the next SharePoint version. To create SharePoint 2013 workflows you need to install and configure the Workflow Manager 1.0.

There are two ways to install the Workflow Manager 1.0. The easy way is to download and run the online installer directly on the SharePoint server. You can download the Workflow Manager 1.0 online installer using this link: http://go.microsoft.com/fwlink/?LinkID=252092. But what if there is no internet connection available on the SharePoint server? Then you should use the offline installation guide below. Let's get started!

Preparation
Before you install the Workflow Manager make sure the corresponding SharePoint 2013 farm is up and running. Use the same setup user as you did for the SharePoint installation.
Check the prerequisites and supported platforms.
Configure the Windows Firewall on the SQL server to allow incoming traffic on the TCP ports 12290 (HTTPS) or 12291 (HTTP) in the Windows Firewall on your SQL server(s) for incoming traffic. For more information see: Windows Firewall für den SQL Server Zugriff konfigurieren or Open a port in Windows Firewall.

Installation
On a client with internet access download the Web Platform Installer v4 (WebPI) command line tool: http://download.microsoft.com/download/7/0/4/704CEB4C-9F42-4962-A2B0-5C84B0682C7A/WebPlatformInstaller_amd64_en-US.msi.
Get more information about the Web Platform Installer v4 (WebPI) command line tool.

Run the WebPlatformInstaller_amd64_en-US.msi on a client with internet access.
2013-10-11_154303
Click Next.

2013-10-11_154408
Click Install.

2013-10-11_154419
Check the Workflow Manager 1.0 and click I Accept.

2013-10-11_154726

2013-10-11_154735
Click Continue.

2013-10-11_154756
Click Finish.

Open the Workflow Manager PowerShell with administrative rights and execute the following command:
webpicmd /offline /Products:WorkflowManager /Path:C:\temp\WorkflowManager
webpicmd /offline /Products:WorkflowManagerRefresh /Path:C:\temp\WorkflowManager

Adjust the path if you wish to save the offline files in a different location.
2013-10-11_155455

Copy the WorkflowManager folder from the source server to C:\temp on the target server (this will probably be a SharePoint server). Note: The WorkflowManager folder may be used as a full offline installer package on every server you need to install the Workflow Manager in offline mode.

On the target server (probably a SharePoint server) log on with the SharePoint setup user and open the command prompt with administrative rights. Execute the following two commands:
cd c:\temp\WorkflowManager\bin
and
WebpiCmd.exe /Install /Products:WorkflowManager /XML:c:/temp/WorkflowManager/feeds/latest/webproductlist.xml
WebpiCmd.exe /install /Products:WorkflowManagerRefresh /XML:c:/WorkflowManager/feeds/latest/webproductlist.xml

Adjust the commands above if you use different paths.
2013-10-11_162147

2013-10-11_162313

In larger SharePoint environments you may install the Workflow Manager on multiple SharePoint servers.


SharePoint 2016 sessions @ Microsoft Ignite (May 4-8, 2015)

As mentioned in my earlier post "News summary: SharePoint Server 2016" Microsoft announced the next version of SharePoint: SharePoint Server 2016. Microsoft will share the first news about SharePoint 2016 during Microsoft Ignite which occurs from May 4 through May 8 in Chicago. Here's a list of the SharePoint related sessions at Microsoft Ignite.

If you haven't already, it's time to buy your Microsoft Ignite ticket and add those two sessions to your calendar:
The Evolution of SharePoint (Overview and Roadmap)
What's New for IT Professionals in SharePoint Server 2016

Watch this teaser to warm up for Microsoft Ignite!


SharePoint updates are now available through Windows Update

This has been changed. Please read the article SharePoint updates are no longer available through Windows Update.

Starting with the release of SharePoint Server February 2015 Cumulative Updates Microsoft announced to push its SharePoint product updates including non-security updates through Windows Update.

I strongly advise against installing SharePoint updates using Windows Updates or WSUS! From my perspective it's SharePoint updates should be disabled in Windows Update or WSUS or at least set to "Download the updates automatically and notify when they are ready to be installed".
But if you decide to install the updates through Windows Update / WSUS anyway you may configure Windows Update / WSUS to push SharePoint fixes directly to your farm servers. After installing the updates make sure you run the SharePoint Configuration Wizard on every SharePoint server.


SharePoint 2013 Cumulative Updates: February 2015

The February 2015 Cumulative Update for SharePoint 2013 contains numerous hotfixes and improvements for SharePoint Foundation 2013 and SharePoint Server 2013. The cumulative update package is multilingual and contains updates for all languages.

Before you start
Since June 2014 the Cumulative Updates for SharePoint products releases on a monthly basis.
This cumulative update includes all patches since the RTM release, but not the Service Pack 1. You may install the Service Pack 1 before or after installing this cumulative update. Read how-to install Service Pack 1.
Because of the file size the cumulative update package has been divided in three parts; ubersrv.exe, ubersrv_1.cab and ubersrv_2.cab. You have to put them all in the same folder.

Installation instructions

  • Create a SharePoint Farm Backup.
  • Download all SharePoint Foundation and SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm.
  • Restart the User Profile Service on affected servers.

Hotfix KB2920801 for SharePoint Foundation 2013: February 10, 2015
Download
Description of the SharePoint Foundation 2013 update package

Hotfix KB2920804 for SharePoint Server 2013: February 10, 2015
Download
Description of the SharePoint Server 2013 update package

Hotfix KB2920796 for Project Server 2013: February 10, 2015
Download
Description of the SharePoint Server 2013 with Project Server 2013 update package

Hotfix KB2956101 for Office Web Apps Server 2013: February 10, 2015
Download
Description of the SharePoint Server 2013 update package

SharePoint 2013 update portal
http://technet.microsoft.com/en-us/sharepoint/ee748587.aspx