O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required