RM Cloud Service Delivery can assist you with your MIS Sync installation. For further information, please speak to your Sales representative on 01235 645 316 or email getintouch@rm.com, quoting this article.

1. Log on to the SQL database using SQL Server Management Studio.

2. Expand Groupcall and right-click Security.
3. Click New, Login.

4. In the left-hand pane, click General.
5. Enter a login name (i.e., sa, Groupcall or STUD_ADMIN) and click the 'SQL Server authentication' radio button.
6. Enter a password.
7. Clear the 'Enforce password expiration' and the 'User must change password at next login' boxes.
8. From the 'Default database' drop-down menu, select the CMIS database (this can be any name so please double check).

9. In the left-hand pane, select Server Roles.
10. In the right-hand pane, tick the 'public' box.

11. In the left-hand pane, select User Mapping.
12. Map the CMIS database (same as the default database).
13. Under the 'Database role membership for: model' section, tick the 'db datareader' and 'public' boxes.

14. In the Select Schema window, click Browse.

15. Tick the STUD_ADMIN or 'sa_admin' box. If neither are available, tick the 'db_owner' box.
16. Click OK twice.

17. Download the Groupcall Xporter installer from DWN4153727 in the Other Useful Articles section below.
18. Run the Groupcall Xporter installer, following the installation instructions in DWN4153727.
19. In the Facility CMIS Login window (shown below), browse to and select the CDB file in your Facility CMIS client installation folder.
    Note: The CDB file is used by the Facility client to initiate a connection to the CMIS database.
20. Enter the username and password created in steps 1-16 above.
21. Ignore the Config Eportal button and click Next to complete the installation and download the RM Unify scripts.