Note:
- If your enterprise uses remote SQL and SQL Authentication, you can skip this step, because the required credentials are provided during the configuration of MiContact Center Business
- If you do not currently have a copy of Microsoft SQL Server Management Studio installed, you can download a free copy from Microsoft: http://www.microsoft.com/en-ca/download/default.aspx.
To grant SQL Server 2014, or 2016 permissions
- In Windows, open the Microsoft SQL Server 2014, or 2016 program folder and go to SQL Server Management Studio.
- Connect to the desired SQL Server.
- In the left pane, expand the Security tree and select Logins.
- If the desired user is not listed, right-click Logins and select New Login.
- After Login name, type the name of the Windows user account.
Optionally, click Search to search for the user name.
- If you have the users configured in groups on your domain, you can optionally add the group to add all users at once.
If you want to grant SQL Server permissions to a domain group, you must click Search, click Object Types, and select the Groups check box.
- Click User Mapping.
- Under Users Mapped to this login, select CCMData.
- Click OK.
- Under Database role membership for: CCMData, select db_owner.
- Click OK.
Repeat steps 5-11 for all Workforce Scheduling users.