February 12, 2010 at 11:05 am
Hi,
Sorry to start a new thread on this however I did not find an answer in any others so far.
I have a new SQL Server 2008 SP1 x64 running on 2003 Enterprise x64 OS. SQL Service and Agent running under domain acct like all my other 25 servers.
All local permissions appear correct when checked against other server AND documentation.
Running SSMS from both My pc and the server I get the same error.
I can back up to a network path \\servername\foldername fine, but when I try to back up to the local server I get the error:
BackupDiskFile::CreateMedia: Backup device 'F:\MSSQL\BACKUPS\SharedServices1_DB_20100212.bak' failed to create. Operating system error 5(Access is denied.).
I can't think of ANYTHING else to try - except to post here.
Again, I can back up across the network, but not local and I have checked my permissions, sql service accounts, admin, user, have access to read/write and modify the backup folder. It is not inheriting from a folder above it.
Ideas?????
Thanks a million in advance!!!!
Hawkeye
February 12, 2010 at 12:56 pm
Did you try to back up to another drive or folder?
February 12, 2010 at 1:56 pm
Hi yes, I tried to back up to a network drive, which works fine. I also tried to back up to other logical drives, and even created a shared folder on the local server. 🙁
February 12, 2010 at 4:32 pm
This is telling you that the account running SQL Server does not have access to the drive and/or folder. It is a permissions issue and once you correct the permissions - you should be just fine.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 12, 2010 at 5:10 pm
This is telling you that the account running SQL Server does not have access to the drive and/or folder. It is a permissions issue and once you correct the permissions - you should be just fine.
Thanks for the response, however my account does have access to the server. In fact, I elevated permissions (testing only) to Administrator. This didn't work. I also changed the account to Local System and it still did not work 🙁
I've never seen this before, the server is set up from what I can tell, like my production server. Is there something else I could be missing?
Thanks again,
Hawkeye DBA
February 12, 2010 at 5:14 pm
What account is running your SQL Server? Is it local system, local service, network service or a domain user?
Getting an access denied error tells us that SQL Server does not have access to that directory. This has nothing to do with your personal access, or how you are running SSMS - and everything to do with the service.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply