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
Article Type
How To

Product(s)

Environment

Languages

Adding or removing ALTER ANY LOGIN permission for the Vault Service account

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

  1. Start SQL Server Management Studio.

  2. In the toolbar, click New Query.

  3. Enter the following script:

    use Master

GRANT ALTER ANY LOGIN TO "domain\vsa_account"

GO

    where domain\vsa_account is the domain and name of the Vault Service account.

  4. Click Execute.

To remove 'ALTER ANY LOGIN' permission from the Vault Service account

  1. Start SQL Server Management Studio.

  2. In the toolbar, click New Query.

  3. Enter the following script: 

    use Master

REVOKE ALTER ANY LOGIN FROM "domain\vsa_account" CASCADE

GO

    where domain\vsa_account is the domain and name of the Vault Service account.

  4. Click Execute.

Configuring Enterprise Vault Reporting

Reconfiguring the data access settings for Enterprise Vault Reporting

Legacy ID



351081


Article URL http://www.symantec.com/docs/HOWTO28087


Terms of use for this information are found in Legal Notices

Please Sign In

Login using SymAccount.

Knowledge Base Search

Knowledge Base Search

Rate this Article

Help us improve your support experience.

MySymantec

MySymantec

Contacting Support

Contacting Support