Setting Up Database Permissions on an Orchestrate production scheduling software Server
In a multi-user environment, the Orchestrate production scheduling software database needs to be set up to allow access for multiple users. This document details how to grant access to these users on the Orchestrate Server.
A member of domain administrators is required to perform the following operations
Process Summary:
This is an overview of the steps required to set up permissions for your Orchestrate production scheduling software users
1) Create a Windows Group on the domain
2) Allocate domain users into this group
3) Add this Windows Group into the specified SQL Server instance as a login
4) Map this login to all required Orchestrate databases as a user;
Detailed Steps:
Follow the steps below on the Windows Primary Domain Controller (PDC). Note that the following screenshots were performed on Windows Server 2008:
1) Create a Windows Group called “Orchestrate Users” on the domain on the PDC;
2) Allocate necessary domain users into the “Orchestrate Users” domain group on the PDC;
3) Log into the database server containing the Orchestrate database with a domain administrator account;
4) Start Microsoft SQL Server Management Studio and sign into a SQL Server instance where Orchestrate databases are hosted with “Windows Authentication”;
5) Expand “Security” folder in the tree structure in the Object Explorer; right click “Logins” folder and select “New Login …” from the context menu;
6) Type “[Your Domain Name]\Orchestrate Users” into the text box;
7) Click “User Mapping” page from “Select a page” from the left side of the “Login – New” window;
8) Tick all Orchestrate databases from the list and click “OK” button.
