Workflow manger installation on newly established SharePoint 2019 Farm

Question

We have done setup for new SharePoint Farm 2019 (Server1 - all roles and Server 2 - SQL)and created PWA site in that and our requirement is to install workflow manager setup(in Server1) in the same farm.

Approach 1:

Tried to install workflow manager 1.0, service bus and workflow manager client on the same but none of the softwares are available to download.

Even tried to install Microsoft Web Platform Installer 5.1 but software is not available.

We have got Microsoft Web Platform Installer 5.1(WPI) from software old storage but none of the software available in WPI after install it.

I mean Approach 1 could not be implemented.

So instead of above workflow manger setup,

Approach 2:

As Microsoft suggested in the below blogs, we have installed below softwares (SharePointworkflow manager and SharePointworkflow manager client) and Register Spworkflow service using below command but its throwing error that "Register-SPWorkflowService : Unable to connect to the remote service at http://server1:12291/SharePoint/. See
InnerException for more details."

And Even there is no Worflowmanagerment site created in IIS on the server after installing of both SharePointworkflowmanager and SharePointworkflowmanger client.

Port 12290 and 12291 are in open for the server1

sharepointworkflowmanagerclient_x64.msi

sharepointworkflowmanager.msi

Register-SPWorkflowService -SPSite "PWA site url" -WorkflowHostUri "http://server:12291" -AllowOAuthHttp

https://www.microsoft.com/en-us/download/details.aspx?id=104867

https://learn.microsoft.com/en-us/sharepoint/governance/install-and-configure-workflow-for-sharepoint-server

Getting Error Register-SPWorkflowService : Unable to connect to the remote service at http://server:12291/SharePoint/. See
InnerException for more details.

Please suggest what we are missing here in Approach 2. How to implement workflow manager setup in SharePoint 2019.

Answer 1

When running the workflow config wizard with values its throwing the below error: Can you help.

System.Management.Automation.CmdletInvocationException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. ---> System.Data.SqlClient.SqlException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at Microsoft.ServiceBus.Commands.Common.ServerManagementStoreDataContext.CreateServerAdministratorLogin(String loginName)
   at Microsoft.ServiceBus.Commands.Common.ManagementDbContext.CreateServerAdministratorLogin(String loginName)
   at Microsoft.ServiceBus.Commands.Common.SecurityHelper.CreateServerAdministratorRole(String accountName, String connectionString)
   at Microsoft.ServiceBus.Commands.NewSBFarmBase.InstallManagementDB(String connectionString)
   at Microsoft.ServiceBus.Commands.NewSBFarmBase.ProcessRecordImplementation()
   --- End of inner exception stack trace ---
   at System.Management.Automation.Runspaces.AsyncResult.EndInvoke()
   at System.Management.Automation.PowerShell.EndInvoke(IAsyncResult asyncResult)
   at Microsoft.Workflow.Deployment.ConfigWizard.CommandletHelper.InvokePowershell(Command command, Action`3 updateProgress)
   at Microsoft.Workflow.Deployment.ConfigWizard.ProgressPageViewModel.CreateSBFarm(FarmCreationModel model)


has context menu
Compose

Answer 2

Hi vallabhanarayana konda, it is a pleasure to be able to help you.

Here is a tutorial video that I found that worked for me. You can use it as a reference if there are any operational inconsistencies.

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Hope this helps.

Best Regards.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi,

The same issue also, we have newly configured SharePoint 2019 farm and try to configure SharePoint Workflow Manager. But no Worflow management site created.

Any solutions?