How to check for relevant permissions
Please check that the Orchestrate database has the relevant permissions. Below is an overview of the steps required to set up permissions for your Access Orchestrate users:
Create a Windows Group on the domain.
Allocate Domain Users to this group.
Add this Windows Group to the specified SQL Server instance as a login.
Map this login to all required Access Orchestrate databases as a user.
Steps to add permissions to the Windows Primary Domain Controller (PDC)
To add permissions, please follow the steps below on the Windows Primary Domain Controller (PDC):
Create a Windows Group called Orchestrate Users on the domain on the PDC.
Allocate necessary domain users into the Orchestrate Users domain group on the PDC.
Log in to the database server containing the Orchestrate database with a domain administrator account.
Start Microsoft SQL Server Management Studio and sign in to a SQL Server instance where Orchestrate databases are hosted with Windows Authentication.
In the tree structure in the Object Explorer, expand the Security folder.
Right-click the Logins folder and select New Login... .
In the Login Name: field, type “Your Domain Name\Orchestrate Users”.
In the left-hand 'Select a page' menu, select User Mapping..
Tick all Orchestrate databases from the list and click OK.
Alternative Solution
You may have set up individual users' permission groups for the Orchestrate Database from SQL Server Management Studio. New users will have to be added via the following steps:
Log in to SQL Server Management Studio.
Expand the Security folder.
Expand Logins.
Create an individual user permission group e.g. ACCESS/John.Doe.
Compare with the existing permission group.
If the above is already set up and configured, please check the firewall settings or AntiVirus software, which would be blocking the Orchestrate database connection.
Need further help?
If the above doesn't resolve the issue, please chat with support, and include the steps and/or checks already made.