Video Screencast Help
Search Video Help Close Back
to help

Enterprise Vault Service Account and Corresponding Database Security Permissions

Created: 26 Feb 2008 | Updated: 19 Dec 2012 | 3 comments
DP's picture
DP
0 0 Votes
Login to vote
This issue has been solved. See solution.
What database level privileges does the Enterprise Vault service account require for optimum application functionality?
Discussion Filed Under:
,

Comments 3 Comments • Jump to latest comment

TonySterling's picture
TonySterling Trusted Advisor Partner Accredited
Enterprise Vault Service Account and Corresponding Database Security Permissions - Comment:27 Feb 2008 : Link
For Installing, Upgrading, and action that requires creating a new database like enabling Auditing or creating a new Vault Store EV needs DB Creators.
 
From the Install and Config guide:
 
"The Vault Service account must have a SQL login account, with Database Creators permission, for the SQL Server"
 
 
When the application creates the databases it will make the VSA the DBO of the databases. 

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

SOLUTION
0
Login to vote
  • Actions
DP's picture
DP
Enterprise Vault Service Account and Corresponding Database Security Permissions - Comment:27 Feb 2008 : Link
I moved the databases from one SQL 2005 Server to another, but the DB Administrators did not assign the DBO permission to the service account.  According to your previous explenation, the DBO permission is needed.  Correct?
 
Also, when I create/modify the System DSN's to make sure EV is pointing to the new database, should I use the service account or the SQL "sa" account?
 
Thanks!
0
Login to vote
  • Actions
TonySterling's picture
TonySterling Trusted Advisor Partner Accredited
Enterprise Vault Service Account and Corresponding Database Security Permissions - Comment:27 Feb 2008 : Link
You should refer to this technote:
 
 
Yes VSA should be dbo.
 
 

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

0
Login to vote
  • Actions