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...
http://www.robgonda.com/blog/trackback.cfm?72808185-3048-7431-E43408BEF05AAD3C
There are no comments for this entry.
[Add Comment]