Enabling FILESTREAM
Like many other features, FILESTREAM is disabled by default in SQL Server 2012, and you must first enable it before the feature can be used. Enabling FILESTREAM is slightly more involved than enabling other SQL Server features because it requires two distinct steps. First, the feature needs to be enabled for the machine, and then it needs to be enabled for the server instance. These two independent FILESTREAM configuration layers are by design, and they draw a separation of security concerns between the role of Windows administrator and database administrator.
Enabling FILESTREAM for the Machine
The first step is to enable FILESTREAM for the machine by setting an access level. This step can actually be performed at the time that ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
