.NET Articles, Web Devploment, ASP.NET, HTML, Sharepoint 2010, Aamir Hasan
Advertise Here
Advertise Here
Advertise Here
Advertise Here
Advertise Here
Advertise Here
Advertise Here
Advertise Here
Advertise Here



Posted by Aamir Hasan   on Sunday, November 27, 2011 Total Views:  

This example describes how to enable FILESTREAM feature in SQL Server 2008. By default, FILESTREAM is disabled in SQL SERVER 2008. Before going to start file streaming you must have to configure settings in SQL Server database engine.

Following error message will display when you will try to create file stream data type in your table.

Msg 1969, Level 16, State 1, Line 1

Default FILESTREAM filegroup is not available in database 'DATABASE NAME'.


Following settings will apply to enable FILESTREAM in SQL Server Database engine.

Step1: From Start menu, click on All Programs, click to Microsoft SQL Server 2008, click to Configuration Tools and click to SQL Server Configuration Manager as shown.

Step2: SQL Server Configuration Manager Window will open. Now, Click on SQL Server Services, select your SQL Server and go to properties from right click on instance of SQL Server as shown.

Step3: SQL Server Properties dialog box will open, click the FILESTREAM tab. Check the checkbox to enable FILESTREAM for Transact-SQL and click Apply button as shown.

  1. Enable FILESTREAM for transact-sql access:  FILESTREAM option will enable after checking this check box.
  2. Enable FILESTREAM for File I/O streaming access:  You can access FILESTREAM data from Windows by checking this checkbox.
  3. All remote clients to have streaming access to file stream data: Remote client will access the FILESTREAM data by checking this check box.


After applying all above steps, open your Microsoft SQL Server Management Studio and execute the following T-SQL in the query editor as given below.



Note: Following are the FILESTREAM access level options.

  • 0 – Disables FILESTREAM functionality.
  • 1 Enables FILESTREAM for Transact-SQL access.
  • 2 – Enables FILESTREAM for Transact-SQL and Win32 streaming access.
  • 3 – Enables FILESTREAM for Transact-SQL to allow remote client acces
Protected by Copyscape Online Plagiarism Tool

Comments (5) -

John United States
11/27/2011 3:01:25 AM #

To set up FILESTREAM on a failover cluster, set up the primary node for the failover cluster. After the setup finishes, enable FILESTREAM on the primary node by using SQL Server

Phillip Ireland
Phillip Ireland Australia
10/18/2012 7:35:29 PM #

I have an existing SQL2K8R2 failover cluster (2 nodes) and now need to enable FILESTREAM on it. Can I still enable FILESTREAM on the cluster, even after the cluster has already been set up?

Phillip Ireland
Phillip Ireland Australia
10/18/2012 7:40:15 PM #

Also, when applying "EXEC SP_CONFIGURE FILESTREAM_ACCESS_LEVEL, 2", does the value used for the parameter directly equate to which boxes are checked in the FILESTREAM Properties menu?

buy cheap mac makeup
buy cheap mac makeup United States
10/14/2014 6:24:39 AM #

This site is mostly a walk-by means of for the entire data you wanted about this and didn't know who to ask. Glimpse right here, and also you�ll undoubtedly discover it.

Dennis Orm
Dennis Orm United States
6/28/2015 12:48:59 PM #

With havin so much written content do you ever run into any issues of plagorism or copyright infringement? My blog has a lot of exclusive content I've either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my permission. Do you know any techniques to help stop content from being stolen? I'd genuinely appreciate it.|

Margot Pevez
Margot Pevez United States
7/13/2015 3:26:53 AM #

Hello friends, its enormous piece of writing about tutoringand entirely explained, keep it up all the time.|

Pingbacks and trackbacks (1)+

Add comment

  Country flag

  • Comment
  • Preview

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5