MS SQL Server Backup Has Insufficient Permissions
  • 12 Apr 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

MS SQL Server Backup Has Insufficient Permissions

  • Dark
    Light
  • PDF

Problem

When utilizing the "test connection" feature the result indicates insufficient permissions.

This may be related to SQL instance not showing under applications to backup.

Solution

Disable/enable user permission for instance backup.

To disable/enable user permission for instance backup:

  1. In Microsoft SQL Server Management Studio (in the instance): Security > Logins > NT AUTHORITY\SYSTEM
  2. Right click Properties.
  3. Navigate to Server Roles and check sysadmin box.
  4. Click OK.
  5. Test connectivity.

Connectivity should now be OK.



Was this article helpful?