The following article has the details:
How To Enable FILESTREAM Feature On SQL Server 2008
FILESTREAM is a new feature of SQL Server 2008 that supports BLOB file storage on NTFS file shares managed by SQL Server. The FILESTREAM feature is disabled during the default SQL Server 2008 installation.
To enable FILESTREAM feature on SQL Server 2008:
- Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)
- Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)
- Click the FILESTREAM tab and select the checkboxes to enable FILESTREAM and enter a share name for the files, as shown