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