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

There are no trackbacks for this entry.

Trackback URL for this entry:

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