Knowledge Base
Home » Categories » Multiple Categories

SQL Application backup Insufficient permission

Behavior: When utilizing the "test connection" feature the result indicates Insufficient permissions.

-Also, May be related to SQL instance not showing under applications to backup

Resolution: disable/enable user permission for instance backup: in instance -> Security -> Logins -> right click on NT AUTHORITY\SYSTEM -> Properties -> Server Roles -> uncheck/check sysadmin

Example:

 

 

 

In Microsoft SQL Server Management Studio (in instance)

Security>Logins>NT AUTHORITY\SYSTEM> [right click]>Properties

 

Navigate to Server Roles and check "sysadmin" box, click ok

 

Test connectivity should now show everything ok

 

Internal Use

Related Esc/App:

ESC-2514

APP-11988

 

 

Attachments Attachments
There are no attachments for this article.