SQL 2005 failing with Backup Exec 11D

[Mad_Dog]

I am getting the following errors trying to do a SQL backup with 11D on a Windows 2003 R2 server:

Job ended: Friday, August 10, 2007 at 5:40:11 PM

Completed status: Failed

Final error: 0xe0008492 - Database Query Failure. See the job log for details.

Final error category: Resource Errors For additional information regarding this error refer to link V-79-57344-33938

V-79-57344-33938 -

An error occurred on a query to database master.

V-79-57344-33938 - 0x2000e20a (536928778)

I get this on all database files.

No hits in the knowledge base seem to match.

[Ben_L_]

Can you check the SQL error logs on the SQL server for that time to see if they give any more information?


Thanks,

[Mad_Dog]

Ben,

These appear to be the messages in the SQL logs.

 The log file is D:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\LOG

2007-08-10 18:14:34.78 Logon       Error: 18456, Severity: 14, State: 5.
2007-08-10 18:14:34.78 Logon       Login failed for user 'Changeme'. [CLIENT: 192.168.140.212]
2007-08-10 18:14:34.81 Logon       Error: 18456, Severity: 14, State: 5.
2007-08-10 18:14:34.81 Logon       Login failed for user 'Changeme'. [CLIENT: 192.168.140.212]
2007-08-10 18:14:35.45 Logon       Error: 18456, Severity: 14, State: 5.
2007-08-10 18:14:35.45 Logon       Login failed for user 'Changeme'. [CLIENT: 192.168.140.212]
2007-08-10 18:14:35.45 Logon       Error: 18456, Severity: 14, State: 5.
2007-08-10 18:14:35.45 Logon       Login failed for user 'Changeme'. [CLIENT: 192.168.140.212]

Here is the entire situation:

I am upgrading a Windows 2000 with SQL 2000  and backup exec 9.1 to a new box with

 Windows 2003 SQL 2005 and backup exec 11.d with live update getting all updates.

I was getting errors trying to restore the SQL database using backup exec so I did a SQL

backup on the old machine and did a SQL restore on the new one.  This worked fine but

I still could not restore the backup with backup exec.  I decided to just try to do a backup

on the new machine of the database restore using SQL.  The backup would not work.

FYI the new machine has been renamed.  It was given a temporary name so it could be

on our network and get all the software installed and updated. I then put it on a separate

network and renamed it to the name it will be in production.  Since the owner was showing

up as the old name in backup exec I deleted the owner entry from the backup exec tabel

and recreated it.  This seemed to fix the owner problem as far as what is displayed when

you look at login accounts.

When I restore the SQL database I am logged on as Changeme which is the same id

I am trying to get backup exec to use.

ANY IDEAS?     

Thanks for replying.