Backup Exec 2014 cannot connect to SQL database

ClintonK
ClintonK used Ask the Experts™
on
I have installed BackupExec 2014 and attempting to perform a full backup which includes my SQL database instance. When I "test/edit credentials" for the backup job and Test All, my SQL database shows "Test failed, Test recommended". I am unable to change the logon setting because it is greyed out with "user server's logon account". If I change the server's logon account the test still fails.
I'm not sure what account it wants.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Ensure that the Windows user account that you use to back up the SQL instances has System Administrator privileges.

    Ensure that Backup Exec has rights to the following registry keys:

        HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server

        HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQL

Please check below link for same.

http://www.symantec.com/business/support/index?page=content&id=HOWTO74429

Author

Commented:
Thanks. All to do with the user that BackupExec was running under. As a test I changed the user to the system administrator and everything then burst into life. Now I know what the cause is I can configure the backup user correctly.
Cheers

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial