Skip to main content

Error: "No permission" When Displaying the SQL Database Size

Tobias Nessel
Updated

Problem

When you display the size of the SQL database, the message No permission appears.

Cause

The Password Secure SQL service account is missing the VIEW ANY DEFINITION permission at server level. Without it, the account cannot read the database file sizes from the system view sys.master_files.

Resolution

Grant the Password Secure SQL service account the VIEW ANY DEFINITION permission. No further permissions are needed.

  1. In SQL Server Management Studio, connect with an account that is allowed to grant permissions, for example an administrator.

  2. Run the following query. Replace [Service account] with the name of the Password Secure SQL service account, for example [DOMAIN\svc-passwordsecure]:

    USE master;
GRANT VIEW ANY DEFINITION TO [Service account];
  3. Display the database size again.