Rob Gonda's Blog

ooooh nt security

wow, this I've never seen before ... a co-worker was backing up a SQL 2005 database, and somehow, he handle to delete all NTFS permissions in the mdf file... needless to say SQL couldn't open the database.

I logged in into the system and realize that is only had the SYSTEM account, so it even denied me access as an Administrator. When I tried to add permissions for the Administrators group, it said access denied, and let me choose Cancel, Retry, or Ignore ...

Solution: as weird as it sounds, if you choose ignore it will add the permissions regardless... then all you have to do is reboot and the NTFS will use the new permissions when it comes back ... amazing how M$ Windows works...

TrackBacks
There are no trackbacks for this entry.

Trackback URL for this entry:
http://www.robgonda.com/blog/trackback.cfm?72808185-3048-7431-E43408BEF05AAD3C

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
This blog is running version 5.9.003. Contact Blog Owner