Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.)

share|improve this answer
    
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 '11 at 17:41
2  
Take ownership of the file... then adjust permissions as you see fit. –  TheCompWiz Dec 9 '11 at 19:28
    
That did it. Thx. –  Chris Dec 9 '11 at 20:07
    
Glad I could be of help. –  TheCompWiz Dec 9 '11 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 at 9:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.