Fix the SQL tab not displaying with BackupVault Pro

BackupVault Pro automatically detects a running MS SQL service and displays a SQL tab option on the left hand side. Occasionally the box will not be displayed and this is typically due to the permissions set within Microsoft SQL itself.

To fix, follow these steps:

  1. Open the Microsoft SQL Management Studio and login as an authorised user
  2. Expand the Security then Logins folders
  3. Right-click on the NT AUTHORITY\SYSTEM user and select Properties
  4. Select Server Roles and tick the Sysadmin option

  5. Click Ok
  6. Restart the BackupVault ESE service
  7. Open the BackupVault ESE client to view the SQL tab on the left hand side
  8. Right click on the database you wish to backup and select Include