Backup Exec 10d and Microsoft SQL

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.  



Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jtcomstockAuthor Commented:
No, didn't do that as I figured being in the domain admin group would take care of things.  I'll take a look.
jtcomstockAuthor Commented:
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?
jtcomstockAuthor Commented:
I built a new job and everything is working fine.  Not sure what happened.  

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.