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
0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Comments
    There are no comments for this article. Be the first to post a comment.
    Name
    Email
    Security Code Security Code
    Related Articles RSS Feed
    How VSS Works
    Viewed 6421 times since Fri, Jul 3, 2015
    How to run a Speedcheck and Healthcheck
    Viewed 4236 times since Fri, Aug 14, 2015
    How to start the Mac client service daemon if it has stopped
    Viewed 4737 times since Thu, Aug 13, 2015
    Perform a SPCommsTest to the Attix5 Storage Platform
    Viewed 4185 times since Fri, Oct 31, 2014