Avatar of cgbent
cgbentFlag for United States of America asked on

Access to Client DB

I am using BackUp Exec 10d for out backups, we have installed the agents for remote servers and also the SQL agent.

History:

Everything was working fine until I changed the password to the account used to do the backups. We troubleshoot this problem through and through and scrapped that because it was not the prefered user account (restructuring the administrative accounts) we were wanting to use in the end. Created a new user and have been working from there.

Present:

BackupExec itself is fine with the new user account as the deault, credentials appear to be fine. We uninstall the remote SQL agent and re-installed using the new accounts credentials and all went well. The problem is however connecting to the databases through the remote agent.


As far as I can tell, at this moment I have the setup completely duplicated from what was the working setup before all these changes. The current config mirrors the working configuration just using a different user account. All groups and rights access appear to be the same.

Any suggestions would be great.
Storage Software

Avatar of undefined
Last Comment
Vee_Mod

8/22/2022 - Mon
honmapog

What is the problem with connecting to the SQL agent?
I've seen problems where the SQL server selections were not visible in the selection list when the account you use to backup is not part of the "Domain Admins" group.
If that's not the problem, let us know how exactly it fails.
ASKER
cgbent

the point in which is fails is connecting to the SQL. In the "resource credentials" test,  everything passes except connection to the SQL server. Again, there is not a missing permission I can find, I am also doing a very old old old style of troubleshooting where I mirror the current configuration to the one that was working.
honmapog

When comparing, did you compare on the SQL end as well? Does the account have sysadmin rights in SQL?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
cgbent

Credentials at the local machine, sql and domain level have all been applied. All are SysAdmins and account is part of domain admins, local admin and sysadmin at the SQL level. They are even linked and mapped to the databases and inside of the DB security settings themselves.

ASKER
cgbent

I should also mention I am kicking myself in the rear because I had someone else working on this too at one point and they blew out the accounts information in BackUp Exec thinking that we were done with them yesterday and now having thought about the wonderful REPLACE function I cannot do that
ASKER CERTIFIED SOLUTION
cgbent

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Vee_Mod

Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.