Adding or removing ALTER ANY LOGIN permission for the Vault Service account
|Article:HOWTO28087|||||Created: 2010-01-22|||||Updated: 2010-01-26|||||Article URL http://www.symantec.com/docs/HOWTO28087|
If the Enterprise Vault databases are on Microsoft SQL Server 2008, you must grant ALTER ANY LOGIN permission to the Vault Service account before you run the Reporting Configuration utility. You may remove this permission from the Vault Service account when you have quit the Reporting Configuration utility.
To add 'ALTER ANY LOGIN' permission to the Vault Service account
use Master GRANT ALTER ANY LOGIN TO "domain\vsa_account" GO
To remove 'ALTER ANY LOGIN' permission from the Vault Service account
use Master REVOKE ALTER ANY LOGIN FROM "domain\vsa_account" CASCADE GO
Article URL http://www.symantec.com/docs/HOWTO28087