Assigning SQL Server roles to the Vault Service account
|Article:HOWTO58549|||||Created: 2011-08-01|||||Updated: 2013-07-12|||||Article URL http://www.symantec.com/docs/HOWTO58549|
The Vault Service account is the account that Enterprise Vault services and tasks use when accessing Enterprise Vault databases. You must assign a number of SQL Server roles to this account to perform various activities with Compliance Accelerator. The two required roles are as follows:
sysadmin (system administrator). Compliance Accelerator provides the facility to create schedules with which you can conduct searches repeatedly or at some future time. These schedules are SQL Server Agent jobs and, by default, Compliance Accelerator assumes that you want to make a user with the sysadmin role the creator and owner of them.
The dbcreator and sysadmin roles are server-wide roles that may grant more security privileges to the Vault Service account than you are comfortable with. If this is the case, you can give the Vault Service account the minimum required permissions by following the instructions in this article on the Symantec Support website:
Then, after you have installed the Compliance Accelerator client, you must change the value of the security configuration option "Use SQL Server SysAdmin Server Role for Schedules". For instructions on how to do this, see the Administrator's Guide.
To assign SQL Server roles to the Vault Service account
On the SQL Server computer, start SQL Server Management Studio.
In the left pane of the SQL Server Management Studio window, expand the tree to display first the required SQL Server and then the Security folder.
Under the Security folder, double-click Logins to display the users in the right pane.
In the Logins list, right-click the Vault Service account, and then click Properties.
In the Login Properties dialog box, select the Server Roles page.
In the Server roles box, make sure that dbcreator and sysadmin are checked.
Article URL http://www.symantec.com/docs/HOWTO58549