Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

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.  

Thanks,

Jason

0
jtcomstock
Asked:
jtcomstock
  • 3
2 Solutions
 
tatwCommented:
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.
0
 
durindilCommented:
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.
0
 
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.
0
 
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?
0
 
jtcomstockAuthor Commented:
I built a new job and everything is working fine.  Not sure what happened.  

Jason
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now