We have just upgraded to 10.1 and are now using the SQL Agent to backup the databases. (Windows 2003 media server with BE10.1, Windows 2003 database server with SQL 2000 sp3)
When I create a new backup job, I can see the SQL databases on the remote server under the "Microsoft SQL Server" node of the selection list, and have selected (for now) just the master/model/msdb/distribution databases.
When I run the backup, it "completes with exceptions". The backup service account I use is a domain admin and a backup operator, and has a SQL login marking it as system administrator too. In the event log of the remote server is:
Event Type:Error
Event Source:Backup Exec
Event Category:None
Event ID:57860
Date:24/06/2006
Time:11:33:48
User:N/A
Computer:SERVERNAME
Description:
An error occurred while attempting to log in to the following server: "SERVERNAME".
SQL error number: "4818".
SQL error message: "Login failed for user 'MYDOMAIN\BackupAccount'.
".
For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Data:
0000: 18 48 00 00 00 00 00 00 .H......
0008: 00 00 00 00 00 00 00 00 ........
In the job log "errors" section I get
Backup- SERVERNAME Database msdb was not found, or could not be accessed.
And in the "exceptions" sections I get
Backup- COPPER The item SERVERNAME\msdb in use - skipped.
I have also tried changing the login credentials to the SQL "sa" account, but this didn't help, although I don't get the eventlog entry on the remote server.
Thanks in advance