Configuring Roles and Permissions in SQL Server - Honeywell DOC4000 - 7.3 - Installation & Upgrade - Intergraph

DOC4000 Installation Guide

Language
English
Product
Honeywell DOC4000
Search by Category
Installation & Upgrade
PAS Version
7.3

On the SQL Server computer, use SQL Server Management Studio to assign the required permissions:

  • The person running the DOC4000 installation program needs to have at least the dbcreator role on the SQL Server where the DOC4000 database will be created. If using multiple databases, this person must have at least the setup_admin role.

  • The DOC4000DataCollector2 service must run under an account with access to the database. If the DOC4000 database is on a separate server and you chose Windows authentication mode, this service account must have the db_owner role on each primary and secondary database. When using multiple databases, if a secondary database is on a separate server from the primary database, this service account must also have the setupadmin role on the primary database to create a database link.

  • DOC4000 stores Windows event log data in a separate database. If you collect Windows event log data, the account used to connect to the database (SQL login for SQL Server mode or the PASWindowsEventLog service account for Windows authentication mode) must have the following roles:

    • dbcreator and serveradmin server roles

    • If you chose Windows authentication mode, the PASWindowsEventLog service account must also have the db_owner role for the SQL Server where the DOC4000 database is stored and the db_datareader role for the DOC4000 database.

  • If you collect Windows event log data and if you chose Windows authentication mode, the administrator who uses the Admin Utility to create the Windows event log collection database must have at least the dbcreator role on the SQL Server where the DOC4000 database is stored.

To configure SQL Server login roles and permissions:

  1. Click Windows Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio.

  2. Log in with the credentials provided by the site owner.

  3. Expand the Security folder on the left.

  4. Right-click Logins and then click New Login.

  5. Select SQL Server authentication or Windows authentication as appropriate.

  6. Select the appropriate roles for the authentication method you selected. For example, when using SQL Server authentication, you can select the sysadmin role in Server Roles, or you can select the db_owner role under User Mapping for each database used by DOC4000.

  7. Click OK.