Unable to install Symantec Workflow Solution

Products

• Workflow Solution

Issue/Introduction

Unable to install Symantec Workflow Solution giving error related to database credentials:

Database integration strategy failed due to an error: System.Exception: Error setting permissions: Timed out
Granting DB access to users failed. You must manually set up accounts like NETWORK SERVICE and ASPNET to have permissions to this database.
at Installer.Core.MSSQL.AbstractMSSQLDatabaseStrategy.GrantAccounts(String[] accounts)
at Installer.Core.MSSQL.MSSQLDatabaseStrategy.Execute()
Database Configuration could not be installed correct. Installation cannot be continued
Installation Failed.

Environment

Workflow 7.x, 8.x

Cause

The credentials were incorrect for authenticating to the database .

Resolution

Step 1. Installing from out of the box, all the errors mentioned above were fixed by changing the Server Authentication to SQL Server and Windows Authentication mode from Windows Authentication on the SQL database.

Step 2. Create a new account (domain\machineName$) on SQL server with public & sysadmin rights for processManager DB.