How To Enable Filestream In SQL Server

by

Recently, I got a requirement to enable the file stream for my SQL server. I have analyzed and identified the approaches mentioned in this article. In this article, I will walk you through all those approaches individually.

How To Enable Filestream In SQL Server

Let us discuss each approach individually.

Approach-1: Using SQL Server Management Studio (SSMS)

To enable Filestream in SQL Server, follow the steps below.

1. Open SQL server management studio and connect to your server instance.

2. Right-click on the server name from the object explorer and select the properties option as shown in the screenshot below.

how to enable filestream feature in sql server

3. Click on the Advanced tab, select the Full access enabled option from the Filestream access level dropdown under the Filestream section, and click the OK button.

how to enable filestream sql server

4. Finally, click the OK button on the next popup, as shown in the screenshot below.

how to enable filestream in sql server 2019

Check out How to Create Functions in SQL Server

Approach-2: Using SQL script

We can use the below SQL script to enable filestream feature in sql server.

EXEC sp_configure filestream_access_level, 2
RECONFIGURE

After executing the above SQL script, I got the expected output below.

how to enable filestream in sql server 2016

Video Tutorial

Conclusion

Enabling Filestream In SQL Server is crucial for improved performance, efficient storage, seamless integration, etc. You can use any approach explained in this article to enable this feature.

You may also like following the articles below.