SQL Server Backup: Test Connectivity With Insufficient Permissions

Problem

When testing connectivity to an SQL Server database for backing up, the Test Connectivity feature indicates Insufficient permissions.

Solution

In the Microsoft SQL Server Management Studio, logged in as the database administrator, in the Object Explorer:

1. Navigate to instance > Security > NT AUTHORITY\SYSTEM where instance is the SQL Server instance.
2.  Right-click NT AUTHORITY\SYSTEM and select Properties.
3. In the Login Properties window, select Server Roles.
4. Check sysadmin.
5. Click OK.