Enabling FILESTREAM
Like many other features, FILESTREAM is disabled by default in SQL Server 2008, and you must first enable it before the feature can be used. Enabling FILESTREAM is slightly more involved than configuring other SQL Server features because it requires two distinct steps. First the feature needs to be enabled for the machine (Microsoft Windows service), and then it needs to be enabled for the server instance. These two FILESTREAM configuration layers are by design, in order to draw a separation of security responsibilities between the roles of Windows administrator and SQL Server 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 ...
Get Programming Microsoft® SQL Server™ 2008 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.
