O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

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