.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 (4) -

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.

natural clear vision pdf
natural clear vision pdf United States
12/19/2015 11:10:03 AM #

Can I simply say what a reduction to find someone who actually is aware of what theyre talking about on the internet. You undoubtedly know easy methods to carry an issue to light and make it important. Extra people have to read this and understand this facet of the story. I cant believe youre not more popular since you definitely have the gift.

natural clear vision free
natural clear vision free United States
12/19/2015 8:14:29 PM #

I’m not that much of a internet reader to be honest but your sites really nice, keep it up! I'll go ahead and bookmark your site to come back down the road. Cheers

Pingbacks and trackbacks (1)+

Add comment

  Country flag

  • Comment
  • Preview

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5