Updated: June 6, 2016Applies To: SQL Server 2016This topic describes how to grant the SQL Server Database Engine, file system access to the location where database files are stored.The Database Engine service must have permission of the Windows file system to access the file folder where database files are stored.With traditional file systems, the way in which data is written is inherently vulnerable to unexpected failure causing file system inconsistencies.Because a traditional file system is not transactional, unreferenced blocks, bad link counts, or other inconsistent file system structures are possible.The utility repairs known problems specific to UFS file systems.The per-service SID is derived from the service name and is unique to each service.The topic Configure Windows Service Accounts and Permissions describes the per-service SID and provides the names in the section Windows Privileges and Rights.
Beginning with SQL Server 2012 permissions are assigned to the per-service SID for each of its services.
This system helps provide service isolation and defense in depth.
It is the per-service SID that must be assigned the access permission on the file location.
This utility has traditionally served two purposes, those of file system repair and file system validation.
Permission to the default location is configured during setup.
If you place your database files in a different location, you might need to follow these steps to grant the Database Engine the full control permission to that location.