SQL server permissions

The SQL server permissions required to create a database and connect to it are listed in the table below.

Authentication Account Privileges required Required to
SQL authentication Database Creation Account sysadmin

Check the disk size on the database server.

Note: This account is used only during installation and is not be saved anywhere in Certification Manager.
Database Connection Account

setupadmin

Requires following roles on the report server database

  • db_owner database role
  • RSExecRole

Add the link server in this scenario:

  • If an ODBC connection is selected during data source creation, the sysadmin role is required in addition to the setupadmin role, in order to add login credentials to the link server. For more information, refer to http://msdn.microsoft.com/en-us/library/ms189811.aspx
Note: Once the ODBC connection is successfully created, the ‘sysadmin’ privilege may be revoked, but will be required if an ODBC connection needs to be created again.
db_owner of IRC and the Certification Manager database
  • Connect to the IRC database.
  • Import custom data through CSV files.
Note: The db_owner of the Certification Manager database is set during installation.
bulkadmin Import application data and users.
Windows Authentication Database Creation/ Connection Account

sysadmin

Requires following roles on the report server database

  • db_owner database role
  • RSExecRole

Create the database and database schema.

Note: For Windows authentication, the database creation and connection accounts are the same. After installation, remove the sysadmin privileges and assign the setupadmin privileges as described in the SQL authentication section above.
bulkadmin Import application data and users