Hi,

SQL Server 2008 changes the way FILESTREAM is enabled.  I didn’t find the information as quickly as I would like have, so I wanted to post the information in case someone else runs into the same issue. 

There are two changes that are needed. 

The first change required, is within the SQL Server Service:

1. Open SQL Server Configuration Manager, click on SQL Server Services and then locate the SQL Server service in the right pane.

2. Right-click the service and then click Properties.

3. In the SQL Server Properties dialog box, click the FILESTREAM tab.

4. Select the Enable FILESTREAM for Transact-SQL access check box.

5. If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.

6. If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.

7. Click Apply.

The second change required, is to execute the code below within a New Query window.

EXEC sp_configure filestream_access_level, 2
RECONFIGURE