Join Gerry O'Brien for an in-depth discussion in this video File system security, part of Securing SQL Server 2012.
SQL Server storage or data in files that reside in the servers disk drives.…You can secure the network and you can secure SQL Server using roles and log ins.…But if you don't secure the file system, theft of your data is still a possibility.…File system security starts with the operating system itself.…It's highly recommended that you install SQL Server on…a system that is using the NTFS file system.…NTFS is the preferred file system…for SQL Server installations because it is more stable than the…file allocation table file system, more commonly known as FAT or FAT32.…
NTFS enables security features that are not found in the FAT file system.…You have the ability to specify file…and directory access control lists, commonly known…as acls, which allow for very specific…permissions and restrictive settings on files and directories.…It's important to understand…the inheritance architecture of the NTFS file permissions, when…you apply them to directories and files in those directories.…The inheritance architecture means that you can incorrectly apply a configuration,…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network