March 9, 2011 at 9:41 am
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!
Date3/7/2011 2:00:01 AM
LogSQL Server (Current - 3/9/2011 3:03:00 AM)
SourceLogon
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]
LogSQL Server (Current - 3/9/2011 3:03:00 AM)
SourceLogon
Message
Error: 18456, Severity: 14, State: 11.
March 9, 2011 at 7:00 pm
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.
January 28, 2013 at 12:38 pm
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 ;-)) then you need to check that all the permissions for that user running the third party tool has been granted.
January 29, 2013 at 7:47 am
I'm pretty sure JKG has done this before. 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply