SQL Server login Server Roles needed for Backup Exec User

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » SQL Server login Server Roles needed for...

SQL Server login Server Roles needed for Backup Exec User

Rate Topic

Display Mode

Topic Options

Author

Message

jane.simmons

Posted Wednesday, March 09, 2011 9:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 04, 2011 9:17 AM
Points: 1, Visits: 52

SQL 2008r2 ---- Windows Server 2008 Standard
I want to create a new SQL server login to allow Backup Exec to pull backups from our SQL Server that have been created by an SQL Maintenance plan. I have created a Domain User to accomplish this and believe Widnows Authentication is what I need to use.
Here’s a bit of history: This job was preivously done under another user’s name, who had ‘ sysadmin’ server roles, abelow are the errors received after the user removed his login for extracting the backups via Backup Exec. . What I don’t know is the following:
What are the minumium Server roles needed for this User to be able to login into the SQL server and pull backups?
Thanks in advance for your help!

Date 3/7/2011 2:00:01 AM
Log SQL Server (Current - 3/9/2011 3:03:00 AM)
Source Logon
Message
Login failed for user 'XX\xxxBackupExec'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: xx.xx.x.xxx]
Log SQL Server (Current - 3/9/2011 3:03:00 AM)
Source Logon
Message
Error: 18456, Severity: 14, State: 11.

Post #1075668

JKG

Posted Wednesday, March 09, 2011 7:00 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 4:07 PM
Points: 421, Visits: 711

Try db_backupoperator on each database. You'll need to add the user to the dbcreator role at the server level if you want the user to be able to verify backups as well.

Post #1075974

sam-770000

Posted Monday, January 28, 2013 12:38 PM

Valued Member

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:31 AM
Points: 61, Visits: 217

JKG above hit the nail on the head. But to add to that, if you are using a third party tool that uses extended procedures (e.g. Redgate SQL Backup - excellent tool Wink

) then you need to check that all the permissions for that user running the third party tool has been granted.

Post #1412606

Ed Wagner

Posted Tuesday, January 29, 2013 7:47 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856, Visits: 528

I'm pretty sure JKG has done this before. BigGrin

Post #1413059

« Prev Topic | Next Topic »

Permissions