Locate WorkflowHostUri

Recently I was doing Installation and Configuration of Workflow Manger 1.0 for SharePoint 2013 Designer Workflows.

After completing the Installation and Configuration there is another step to register the workflow service with SharePoint using Register-SPWorkflowService poweshell command.


Register-SPWorkflowService -SPSite 'SiteCollectionURL' -WorkflowHostUri 'workflowhostur'


WorkflowHostUri value is your the SharePoint Server's fully qualified name with port 12991
on which the Workflow Manager is installed.

To get the computer's FQDN name, right click on "My Computer" or "This PC", select "Properties" and see for Full Computer Name,

Aliasing Sql Server

To give an alias name to your Sql Server, follow the below steps:

1. Login to the machine/server (typically a WFE) from where you want to access the SQL server             using its alias name.
2. Go to C:\Windows\System32 and locate and double click on "cliconfg"
3. "SQL Server Client Network Utility" window opens as shown below

4. Go to "Alias" tab, click "Add"
5. Enter "Server alias" name (SqlServer01)
6. Under "Network alias",  Select "TCP/IP"
7. Under "Connection Parameters", enter Server Name (actual Sql Server name - SPSQL01) and click     "OK"

8. You should see the alias has created as shown below

9. Do PING <aliasname> from command prompt and confirm the alias is created successfully.