24.1 C
Cuttack
Monday, December 4, 2023
HomeSQL ServerEnable and change FILESTREAM Setting SQL Server 2008 R2 Express

Enable and change FILESTREAM Setting SQL Server 2008 R2 Express

When you are trying to restore one database and you stuck with the error showing FileSTREAM feature is disabled.

 

Solution
To enable and change FILESTREAM settings

    On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

    In the list of services, right-click SQL Server Services, and then click Open.

    In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.

    Right-click the instance, and then click Properties.

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

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

    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.

    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.

    Click Apply.

    In SQL Server Management Studio, click New Query to display the Query Editor.

    In Query Editor, enter the following Transact-SQL code:

    EXEC sp_configure filestream_access_level, 2
RECONFIGURE

    Click Execute.

    Restart the SQL Server service.

I can reach at : durgacharanojha@yahoo.co.in
Durga Charan Ojhahttps://lifeonnetwork.com/
I am a proud Indian, proud father, a blogger, Being in a profession as System administrator, my passion is troubleshooting computer issues, I do like sharing solutions through blogging making videos of solving issues.
RELATED ARTICLES

2 COMMENTS

  1. I’m trying to enable Filestream in SQL Server 2008 and I Do not have SQL Server Management Studio component installed on my computer, all info I’ve found already needs the Management studio, how could I enable it without it? thanks

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular