1

Last week I provisioned a new Windows 2008 R2 box from my hosting company and copied my databases files to the file system. It became necessary to reimage the OS on the box so they left the database files on the local drive and reimaged the box. Now that the image is complete I’ve logged back into the box and tried to reattach the database files but I received an ‘Access Denied’ error. On 8 of the 10 files I was able to add the Administrator account to the file and complete the attachment but on 2 files the Security tab is blank except for the message “You do not have permission to view or edit this object's permission settings.”

Can anybody tell me how I can access the permission settings for the 2 rouge files?

Thanks, Chris

1 Answer 1

1

What user is the sql server running as? ... does that user have full permissions? (check services manager and look at the "Log On As" user.)

6
  • SQL is running as LocalSystem. I don't think SQL is the problem. The problem is that I can't change the permissions on the actual database file. I was able to change 8 out of 10 but there are 2 of which I'm locked out.
    – Chris
    Dec 9, 2011 at 17:41
  • 2
    Take ownership of the file... then adjust permissions as you see fit.
    – TheCompWiz
    Dec 9, 2011 at 19:28
  • That did it. Thx.
    – Chris
    Dec 9, 2011 at 20:07
  • Glad I could be of help.
    – TheCompWiz
    Dec 9, 2011 at 20:09
  • Hey, I'm having the same problem now. What does "Take ownership of the file" mean? How do you do that? @Chris?
    – Shaul Behr
    Oct 26, 2014 at 9:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .