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

Start SQL Server Management Studio.
In the toolbar, click New Query.
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.
Click Execute.

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

Start SQL Server Management Studio.
In the toolbar, click New Query.
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.
Click Execute.