June 1, 2009 at 5:21 am
What Permission/Right required in addition to Database Role: db_backupoperator
I would like to give limited rights to the Operator responsible for taking backup of the database.
Operator is using SQL Management Studio to take backup. When Operator right click on the database > tasks > backup > Add button to open "Select Backup Destination" and try to browse the backup destination on disk, he is getting following error:
C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path of file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name Control in the Locate Dialog Box
The SQL Server service runs as Local System, and giving access to path above doesn't help
It work if I make operator part of sysadmin server roles BUT I do not want to give sysadmin rights and SQL Server service account has necessary permission to read/write on to the disk.
I know that if the operator type the drives than it works but I am looking for the solution so operator can browse the directory.
Any ideas?
June 1, 2009 at 5:50 am
Hi,
I did a small test at my end.
1) Created a local windows account (Gurpreet\test).
2) In SSMS created a WINDOWS LOGIN which is mapped to this newly
created windows account.
3) Set default database "ADVENTUREWORKS". Under user mappings
selected ADVENTUREWORKS as database and DB_ROLE :
DB_BACKUPOPERATOR.
4) Started new SSMS using RUN AS and connected using this windows
account.
5) Tried to take backup and it works. I didn't get any problem.
Can you please try to follow these steps and check if it works. I am sure you did the same but still......
Regards
GURSETHI
June 1, 2009 at 6:25 am
Thanks GURSETHI.
It works for Windows Account.
In my case I want to make it work for SQL Server Account. I mean SQL Authentication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply