Act 7 SQL Database Selection Problem in Backup Exec 12
Posted on 2010-01-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.