SQL Server Backup problem when browsing to the directory
Posted
by Richard West
on Server Fault
See other posts from Server Fault
or by Richard West
Published on 2010-04-06T16:04:02Z
Indexed on
2010/04/06
16:13 UTC
Read the original article
Hit count: 406
sql-server-2005
|backup
I want to allow a group (eg. 'BackupManagers') who can only preform backup and restore operations on certain databases. When creating the BackupManagers user account I checked db_backupoperator.
When the user logs in to create a backup they get an error message similar to the following when the select Tasks -> Backup -> Click on Add in the destiantion block -> click on the "..." button to browse
TITLE: Locate Database Files - MYSERVER\SQL2005 E:\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or 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.
I have confirmed that the user has permissions to the folder. I have even created a share to this folder and had them access it through explorer. They are able to create and delete files within the folder.
I have found that if they type in the path to the file instead of using the "..." button to browse the directory tree then they can create a backup file fine.
Why is the browse button not working as expected?
Thanks!
© Server Fault or respective owner