Solved

Enable and change FILESTREAM settings...

Posted on 2013-06-28
5
419 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now