Post reply

Does changing the service account update the NTFS permissions?

  • November 22, 2014 at 4:56 am

    #313283

    If you were to do a fresh install it would set permissions on the disk so everything just works.

    Now when changing the service account (e.g. to a domain user) use the configuration manager, does it do the same magic (possibly sans if the database data/log files are on another disk)? Or do you need to trawl through the dozens of folders and assign rights manually?

  • November 22, 2014 at 7:19 am

    #1760326

    the sql server ntfs permissions are secured by the use of either local groups in ealier versions of windows or by virtual server accounts for Windows 2008 on. As the group or virtual acct map to the NTFS ACLs changing the sql server service acct is not affected, the new service acct is mapped to the group or virtual service acct.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply