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?
Shivam Dogra is a cloud database developer and Team Lead at TSInfo Technologies, where he has worked since June 2021. He writes the SQL Server and Oracle tutorials on DatabaseFAQs.com, covering queries, joins, stored procedures, triggers and permissions. Shivam holds a Master of Computer Applications (MCA) from Chandigarh University.