Xporter: Create a CMIS stud_admin account

Summary

Create a SQL account in CMIS for Xporter services.

Answer

Scope

  • Steps to create a suitable user in Facility CMIS as part of the setup to connect with Xporter or Xporter on Demand.

Instructions

1. Log into the SQL database using SQL Server Management Studio.


2. Expand and right-click on Security.


3. Click New > Login.


4. Click General from the panel on the left.
5. Add a login name – we recommend typing Groupcall or STUD_ADMIN.
6. Set to SQL Server authentication and enter a password.
7. Untick Enforce password expiration and User must change password at next login.
8. Select default database to the CMIS database (this can be any name so double check).
 


9. From the left panel, click Server Roles > Tick Public.


10. From the left panel, click User Mapping.
11. Map the CMIS Database (same as the default database).
12. Under Database role memberships, tick db_datareader and public.
13. Click the .... icon under the Default Schema column.


14. Click Browse.


15. Tick STUD_ADMIN or sa_admin (if neither are available use db_owner) > click OK.


16. Click OK from the Login Window.