Solved

Enable and change FILESTREAM settings...

Posted on 2013-06-28
5
422 Views
Last Modified: 2013-07-11
I am following the instruction from:

http://msdn.microsoft.com/en-us/library/cc645923.aspx#enabling

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.
FileStreamError.png
0
Comment
Question by:Mike Eghtebas
  • 3
5 Comments
 
LVL 11

Expert Comment

by:Louis01
ID: 39284033
Try the instructions in this link perhaps:
http://evry1falls.blogspot.com/2012/07/wmi-error.html

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

Author Comment

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

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 500 total points
ID: 39289152
DB Server properties
0
 
LVL 33

Accepted Solution

by:
Mike Eghtebas earned 0 total points
ID: 39300049
PatelAlpesh,

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"
0
 
LVL 33

Author Closing Comment

by:Mike Eghtebas
ID: 39316916
good solution description.

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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

821 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