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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.