Act 7 SQL Database Selection Problem in Backup Exec 12

Posted on 2010-01-12
Medium Priority
Last Modified: 2013-12-01
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.
Question by:granite03
LVL 32

Expert Comment

by:Rodney Barnhardt
ID: 26293780
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.
LVL 30

Accepted Solution

Mike Lazarus earned 2000 total points
ID: 26293940
You need the SA Pass utility to give Backup Exec the credentials to backup the ACT! SQL database.

If you're in Europe, this is free... at least for ACT! Premium users (not sure if not Premium)

Another idea is to use the ACT! backup option to back up the database and have Backup Exec skip the database and backup the one you created.

See http://www.experts-exchange.com/articles/Database/Contact_Management/ACT/Automating-backups-for-ACT-by-Sage.html

Author Closing Comment

ID: 31675997
Link took me to a solution that worked like a dream.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question