database:mssql:fs_acl [Eureka Moment]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Grant MSSQL instance service access to new data folder ======
  - Using Windows Explorer, navigate to the file system location where the database files are stored. Right-click the file system folder, and then click Properties.
  - On the Security tab, click Edit, and then Add.
  - In the Select Users, Computer, Service Account, or Groups dialog box, click Locations, at the top of the location list, select your computer name, and then click OK.
  - In the Enter the object names to select box. For the Database Engine per service SID name, use **NT SERVICE\MSSQLSERVER** for a default instance, or **NT SERVICE\MSSQL$InstanceName** for a named instance.
  - Click Check Names to validate the entry. (If the validation fails, it might advise you that the name was not found. When you click OK, a Multiple Names Found dialog box appears. Now select the per-service SID name, either **MSSQLSERVER** or **NT SERVICE\MSSQL$InstanceName**, and then click OK. Click OK again to return to the Permissions dialog box.)
  - In the Group or user names box, select the per-service SID name, and then in the Permissions for <name> box, select the Allow check box for Full control.
  - Click Apply, and then click OK twice to exit.