FILESTREAM must be enabled twice, once by the Windows administrator and then again by the SQL Server administrator. The reason for this is because FILESTREAM is somewhat of a hybrid feature. Yes it's primarily a SQL Server feature, but because of its tight integration with the NTFS file system on Windows, it requires a file system filter drive to be installed, which is something only a Windows administrator can do. Typically the Windows administrator prepares an NTFS volume and enables FILESTREAM, and then the SQL Server administrator enables FILESTREAM separately at the server instance level before creating a FILESTREAM-enabled database. This same access level must be specified in both places.
Of course, this is not an issue if you are one person that acts as both the Windows and SQL Server administrator, but otherwise, both need to get along and they need to agree on the access level that FILESTREAM should be enabled for.
Enabling FILESTREAM for Windows
Enabling FILESTREAM for SQL Server
No comments:
Post a Comment