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.
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.
4. Finally, click the OK button on the next popup, as shown in the screenshot below.
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
RECONFIGUREAfter executing the above SQL script, I got the expected output below.
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.
- How To Enable Query Store In SQL Server
- How to Get Auto Increment ID in SQL Server
- How to Select the Latest Record in SQL Server?
- How to Execute the Stored Procedure for Updating the SQL Server?
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
