Enable and change FILESTREAM settings...

Posted on 2013-06-28
Medium Priority
Last Modified: 2013-07-11
I am following the instruction from:


I am working with SQL Server 2008R (the above is for SQL Server 2012) assuming the process is the same.

There are 13 steps in this link. At the very first step:
1, On the Start menu, point to All Programs, point to Microsoft SQL Server Code-Named 2012, point to Configuration Tools, and then click SQL Server Configuration Manager.

I am getting an error stating "Cannot connect to WMI provider..."

Q1: How can I find out whether the Filestream is already enabled or not?
Q2: How can I deal with this error (see the attached image)?

FYI: Per MCTS 70-433 Training Kit, I am trying to Enable FILESTREAM settings to install some sample databases from the companion CD provided with the book.

Thank you.
Question by:Mike Eghtebas
  • 3
LVL 11

Expert Comment

ID: 39284033
Try the instructions in this link perhaps:

p.s. Right above the heading in the MSDN article, you can select the SQL version...
LVL 34

Author Comment

by:Mike Eghtebas
ID: 39286034
In this case, the version difference is not an issue I believe.
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 2000 total points
ID: 39289152
DB Server properties
LVL 34

Accepted Solution

Mike Eghtebas earned 0 total points
ID: 39300049

Thank you for answering question 1.

Right-click on SQLEXORESS to select properties then
Select Advanced and change Filestream Access Level

I have "Full access enabled"
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 39316916
good solution description.

enable/disable of file stream identical for both 2008 and 2012

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question