Video Screencast Help

BE 2012 login errors with Windows SQL 2008 R2

Created: 19 Nov 2012 • Updated: 21 Nov 2012 | 3 comments

I am trying to backup a SQL 2008 R2 server with BE for Windows 2012.  The backup fails because the login failure below.   Any else able to backup a SQL 2008 R2 database server?

Log Name:      Application
Source:        Backup Exec
Date:          11/19/2012 1:03:55 PM
Event ID:      57860
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
An error occurred while attempting to log in to the following server: "\MSSQLSERVER".
 SQL error number: "4818".
 SQL error message: "Login failed for user 'RODGER-1\backupagent'.

 For more information, click the following link:
Event Xml:
<Event xmlns="">
    <Provider Name="Backup Exec" />
    <EventID Qualifiers="8192">57860</EventID>
    <TimeCreated SystemTime="2012-11-19T18:03:55.000000000Z" />
    <Security />
    <Data>Login failed for user 'RODGER-1\backupagent'.

Comments 3 CommentsJump to latest comment

Donald Eady's picture

Verify that the service account has the appropriate rights

additionally you may want to manage the system logon accounts and change the password and just reenter the password to verify that it was not previously mistyped.

I hope this posting was helpful


pkh's picture

Try renaming your  bedssql2.dll file to bedssql2.old. See this article

VJware's picture

Renaming the dll would effectively disable the usage of the Agent for SQL..

Pls ensure then account used by Backup Exec has sysadmin privileges...and dbdatareader, dbdatawriter is present under user mapping for those databases as well...Give full permissions to the Backup exec account to the SQl registry key on the SQL server as well.