granite03
asked on
Act 7 SQL Database Selection Problem in Backup Exec 12
I am attempting to backup Act 7 SQL database using Backup Exec 12 over a Windows 2003 domain. I am receiving the following error message when attempting to expand the SQL folder in Backup Exec through the Active Directory domain, as the database resides on a separate 2003 standard server. Backup Exec is running on an SBS 2003 standard server.
Failed to log on to: Microsoft SQL Server "ACT7"
Logon account: Administrator
An attempt to connect to SQL Server has failed. The logon account may have invalid credentials, or the logon account may have been applied to the wrong resource.
Please select a logon account from the list.
I must also mention that, previous to a major infrastructure upgrade there was only one 1 Windows 2003 Standard server running Backup Exec 12 along with the Act
SQL database. The server was demoted and an SBS server was put in its place as a domain controller. The hostnames of the servers were also changed. Now for some reason there is some kind of security issue expanding the SQL folder in Backup Exec for selection.
I am certain the credentials entered for the account which is the administrator account for the domain is correct. It doesn't even matter if I re-enter the credentials, I still get the same error message.
Failed to log on to: Microsoft SQL Server "ACT7"
Logon account: Administrator
An attempt to connect to SQL Server has failed. The logon account may have invalid credentials, or the logon account may have been applied to the wrong resource.
Please select a logon account from the list.
I must also mention that, previous to a major infrastructure upgrade there was only one 1 Windows 2003 Standard server running Backup Exec 12 along with the Act
SQL database. The server was demoted and an SBS server was put in its place as a domain controller. The hostnames of the servers were also changed. Now for some reason there is some kind of security issue expanding the SQL folder in Backup Exec for selection.
I am certain the credentials entered for the account which is the administrator account for the domain is correct. It doesn't even matter if I re-enter the credentials, I still get the same error message.
Rodney Barnhardt
The error says the logon account is "Administrator" is this the local account or the domain account? If it is the local account where BE is running, that may be th eproblem. It would be best to use a domain account to access the agent on other servers.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Link took me to a solution that worked like a dream.