April 14, 2009 at 9:17 am
We installed sql server 2005 on a windows 2008 server 64 bit using a domain account for sql service account.
I installed it on E drive. And put the data location to F drive.
Today I tried to back up a database to E drive. But I got an error:
E:\program files\microsoft sql server\MsSql.1\mssql\backup
cannot access the specified path of file on the server. Verify that you have the necessary securtiy priviledges 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 conrol in the located dialog box.
I trie to browse to the folder, I can only browse the program files directory, then it stops.
I also tried to type the file name, then I got another message, backup failed for server 'ourservername', additional information:
system.data.sqlclient.sqlError: cannot open backup device , operating system error5 (access is denied)
I can backup to F drive though, but I want to separte data file location and back up location.
The strange thing is even I make the service account an administrator of the computer, I got the same error.
I even tried to login as this sql service account into the server, I can browse and access all the drives, for I'm the administrator, but still I cannot back up the database, for I got the same error.
Anything I missed?
Please help.
April 14, 2009 at 9:28 am
Windows 2008 is a lot more restrictive (sometimes to the point of being annoying) where security is concerned. You seem to be taking a backup in the default folder. Users / local admins don't usually have access to this folder.
You will need to either gain access to this folder or I suggest taking a backup on the F drive where you already have access.
ps: Windows should give you the option to get access to the folder while trying to access it. Alternately you could Run As administrator and access that path as well.
April 14, 2009 at 9:37 am
Thank you.
I'm glad it can still be backed up on F drive. But still I feel strange why the administrators cannot access E:\program files\microsoft sql server\MsSql.1\mssql\backup
I thought administor account should be able to access any drives on the computer, is that right?
Also the service account can browse and access the file if in windows explorer, but not from sql mangement studio- back up tool. Is that strange?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply