• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 35
  • Last Modified:

Best method to enable SQL filestream

I need to enable filestream in SQL server, but I've found two ways to do this:

1. Configuration manager > services > instance > properties > filestream > Enable filestream
2. SSMS > Server > Right-click > Properties > Advanced > Filestream access level > Select “Full access enabled”

Which is better (or should they both be set) and is there a difference?

  • 2
1 Solution
Vitor MontalvãoMSSQL Senior EngineerCommented:
They are different things.
In SSCM you really enable the FILESTREAM feature.
In SSMS you define the access level for the FILESTREAM feature.
barnescoAuthor Commented:
Vitor's reply was good. I hadn't had thought to close and resolve this in time. His answered helped.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comment as solution.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now