Updating auditing-related databases

If an upgrade requires an update to the database, you are prompted to run the database maintenance wizard and to select the databases to upgrade. If the wizard can connect to the databases selected and the database upgrade is successful, no further action is required.

You can upgrade audit store databases and the management database interactively using the Database Maintenance Wizard or by running the following command:

setup.exe /database

Upgrading the auditing databases, however, requires specific Windows and database permissions. Before attempting to upgrade the database, verify that you have a user account that meets the following requirements:

  • The Windows account you use to update the database with the Database Maintenance Wizard must be an Active Directory domain user and a local administrator on computer where you are running the setup.exe program.
  • Your Windows or SQL login account must be either a member of sysadmin fixed server role or a member of db_owner database role on each of the database instances being upgraded. If the account is a member of db_owner database role, you must also have the EXTERNAL ACCESS ASSEMBLY permission on each of the database servers hosting the management database and audit store databases.

You can use the following SQL statement to grant the EXTERNAL ACCESS ASSEMBLY permission to a specific user:

GRANT EXTERNAL ACCESS ASSEMBLY TO [DOMAIN\user]

For example, to grant this permission to the account john@acme.com, you might execute the following SQL statement:

GRANT EXTERNAL ACCESS ASSEMBLY TO [ACME\john]