Solved

Enable and change FILESTREAM settings...

Posted on 2013-06-28
5
427 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 34

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 34

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 34

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

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…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

733 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