Backup Exec 10d and Microsoft SQL

Posted on 2006-04-25
Last Modified: 2013-12-01
I'm having challenges with BackupExec 10d in trying to backup four databases.  I get "Authentication failed on connection to server..." when I test in the resource creditentials screen.  I'm using an account that is in the domain admin group and get successful with other parts of the backup job.  

I'm running on SBS2003 and this job was working correctly the first couple of days after setting up BE.  I've looked through the BE configuration and don't see any obivious changes.  

I would appreciate a suggestion on how to get authentication working for the SQL databases on this system.  



Question by:jtcomstock
    LVL 6

    Assisted Solution

    Would you please test backup the files on sql server? If it is successful then it will be the SQL access right problem
    Domain admin is not always admin in SQL databases system. Please also check that the by using Entreprise Manager of SQL to see it supports Windows authentication or not.
    LVL 6

    Accepted Solution

    Does your account that is in the domain admin group have "backup operator" priviledges on that server?  You have to go to the local security policy on that machine, and assign that right to the user account that you are using for backup.

    Author Comment

    No, didn't do that as I figured being in the domain admin group would take care of things.  I'll take a look.

    Author Comment

    I looked over the backup account I'm using and it was not part of the Backup Operators group, I changed that.  I then went into the Domain Controller Security Policy (SBS2003), then to Local Policy, then User Rights Assignments, then Backup Files and Directors.  Backup Operators was listed and I added the account to the list.  After applying I did a gpupdate /force and had no change when I test the resource credentials.  

    I then change the account to use on one of the SQL instances, there are four, to the system logon account, no luck.  Still getting the authentication failure.  

    What next?

    Author Comment

    I built a new job and everything is working fine.  Not sure what happened.  


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
    Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
    This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now