11-19-2012 10:27 AM
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
Computer: GTBST851.rodgers.inc
Description:
An error occurred while attempting to log in to the following server: "gtbst851.rodgers.inc\MSSQLSERVER".
SQL error number: "4818".
SQL error message: "Login failed for user 'RODGER-1\backupagent'.
".
For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Backup Exec" />
<EventID Qualifiers="8192">57860</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2012-11-19T18:03:55.000000000Z" />
<EventRecordID>4835</EventRecordID>
<Channel>Application</Channel>
<Computer>GTBST851.rodgers.inc</Computer>
<Security />
</System>
<EventData>
<Data>gtbst851.rodgers.inc\MSSQLSERVER</Data>
<Data>4818</Data>
<Data>Login failed for user 'RODGER-1\backupagent'.
</Data>
<Binary>18480000000000000000000000000000</Binary>
</EventData>
</Event>
11-26-2012 09:31 AM
Verify that the service account has the appropriate rights
http://www.symantec.com/docs/TECH184449
11-26-2012 06:40 PM
Try renaming your bedssql2.dll file to bedssql2.old. See this article
http://www.symantec.com/docs/TECH29539
11-27-2012 02:06 AM
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.