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.
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.
ASKER
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.
When comparing, did you compare on the SQL end as well? Does the account have sysadmin rights in SQL?
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
Vee_Mod
Community Support Moderator
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.