Fails to backup any SQL items

[Chris_Smith_2]

We have a SBS 2003 server running Backup Exec 10d. About a week ago, we started receiving backup errors related to SQL.

--------------------------------------------------------------------
Completed status: Failed
Final error: 0xe000848c - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again.
Final error category: Resource Errors
.
.
.
Unable to attach to GYNSRV.
V-79-57344-33932 - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again.
Unable to attach to GYNSRV\BKUPEXEC.
V-79-57344-33932 - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again.
----------------------------------------------------------------------


Both SQL services are started. We've tried restarting them, but still receive this error. We are getting the following error in the Application Event logs:

---------------------------------------------------------------------
Event Type:Error
Event Source:Backup Exec
Event Category:None
Event ID:34113
Date:2/16/2007
Time:12:05:40 AM
User:N/A
Computer:GYNSRV
Description:
Backup Exec Alert: Job Failed
(Server: "GYNSRV") (Job: "Full Backup") Full Backup -- The job failed with the following error: Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again.
----------------------------------------------------------------------

We've verified that Administrator is the System Logon Account and that Administrator has full rights to the SQL databases.

If you look at the text based selection list of the backup job, the 2 following items are listed:
----------------------------------------------------------------------
GYNSRV|*.*
GYNSRV\BKUPEXEC|*.*
----------------------------------------------------------------------

But if you view the graphical selection list, no SQL items are listed at all. Nor are they listed if you try to create a new selection list.

Somehow the ability of Backup Exec to see/access SQL items has broken and I'm not sure what to do to fix it, other than a full reinstall of the Backup Exec software.Message was edited by:
Chris Smith

[Stephen_Reece]

Given that the SQL items aren't displayed in the graphical listing, I would first try to push the remote agent onto the SQL server again. Also, if anything has been recently installed that is using port 10000 (BE uses this for NDMP) you will need to edit the Services file on all of the servers and choose another port for NDMP.

Stephen

[Chris_Smith_2]

This is an SBS 2003 Server and the SQL instances are on this server. How would we reinstall just the remote agent?

[Stephen_Reece]

You are absolutely right. Missed the SBS. I see that the employees of Symantec aren't exactly jumping at the bit to help. Let me brainstorm a bit.

To be fair, they are going to eventually have you reinstall the program. You may as well do it, and you can just point it to the existing DB to save your settings. At least that worked the last time we had to reinstall it.