We're currently experencing issues with one of SQL DB backups. Upon backing backing up OS files and folders on the server; all goes well. Yet upon selection the SQL DBs (using the SQL agent licence), the back up fails with the below error/s.
We have attempted: / backing up just the SQL DBs - FAILED / backing up just the OS files on the server - SUCCESS / creating a new backup job just for the SQL DBs - FAILED / logging onto SQL Ent Mngr with the exact credentials used in the failed backup of the SQL DBs - SUCCESS
--------------------------------------------------------------------------- Job Completion Status Job ended: Wednesday, 19 January 2005 at 1:12:16 AM Completed status: Failed Final error: 0xa0008488 - Access is denied.
Final error category: Security Errors
Errors Click an error below to locate it in the job log
Backup - SERVERNAME Unable to attach to SERVERNAME Unable to attach to SERVERNAME
Might be an idea to create a user on your pdc/or on the 2003 server solely for Backup Exec with domain admin/admin etc priviliges, this is what we have had to do when backing up raid systems on a 2003 server, if you try and use the system administrator id of the 2003 box it will deny access.
The event log of the SQL server is showing the following. We have tried the domain 'administrator' account along with numerous SQL admin logins, newly created domain admin accounts etc... still no luck.
An error occurred while attempting to log in to the following server: "SERVERNAME". SQL error number: "4818". SQL error message: "Login failed for user 'backup'. ".
For more information, click the following link: http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml