SQL Server Backup: Test Connectivity With Insufficient Permissions
  • 12 Apr 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

SQL Server Backup: Test Connectivity With Insufficient Permissions

  • Dark
    Light
  • PDF

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.



Was this article helpful?