====== 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 box, select the Allow check box for Full control. - Click Apply, and then click OK twice to exit.