MS SQL Server Backup Has Insufficient Permissions
- 12 Apr 2022
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
MS SQL Server Backup Has Insufficient Permissions
- Updated on 12 Apr 2022
- 1 Minute to read
-
Print
-
DarkLight
-
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:
- In Microsoft SQL Server Management Studio (in the instance): Security > Logins > NT AUTHORITY\SYSTEM
- Right click Properties.
- Navigate to Server Roles and check sysadmin box.
- Click OK.
- Test connectivity.
Connectivity should now be OK.
Was this article helpful?