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





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:





Attachments Attachments
There are no attachments for this article.