SQL Server Backup Has Insufficient Permissions

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.