April 1, 2011 at 3:54 am
Hello there.
I am using Sql Server 2005 Express. I am unable to take any backup to C drive which has NTFS filesystem. The error message says that Access is denied. But when I change the drive to D which has also NTFS filesystem, it succeeds. Windows is installed on C drive but how can it prevent access to root of C drive? I know this may a security issue in windows but I should notice that I am taking backup from an administrator windows account and am logging into SQL Server using windows authentication mode.
Any idea is appreciated.
Thanks.
April 1, 2011 at 4:31 am
Backup processes run under the security setting that is granted to the SQL Server service. Check that for security settings.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 4:44 am
Hi.
I am using windows xp home edition and I noticed it does not support security configuration so it is not possible to grant permissions to service account for a file or folder. I have somehow installed security configuration manager and it started working even without needing to grant permissions for destination folder.
Thanks.
April 1, 2011 at 5:09 am
for XP Home, boot into safe mode to set share\folder permissions via the share and security tabs and then reboot normally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 5:25 am
I have installed security configuration manager and now have security tab in normal mode.
Thanks.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply