Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

When trying to enable filestream to a SQL Server 2008 I've got this message:

There was an unknown error applying the FILESTREAM settings. Check the parameters are valid.

And now in the FILESTREAM tab of the properties of said server I read:

A previous FILESTREAM configuration attempt was incomplete. FILESTREAM may be in an inconsistent state until re-configured

Do you know what might have gone wrong? What parameters is it taking about? Do I need to reset anything to be able to try again?

I've tried with filestream_enable.vbs, but that failed too:

c:\Users\pupeno\Downloads\EnableFilestream>cscript filestream_enable.vbs
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

Machine: .
Instance: MSSQLSERVER
Level: 3
ShareName:

Current Filestream configuration:

InstanceName = MSSQLSERVER
AccessLevel  = 0
ShareName    = MSSQLSERVER
RsFxVersion  = 0103

Calling method EnableFilestream with new level

Method failed: hr = -2147024894


New Filestream configuration:

InstanceName = MSSQLSERVER
AccessLevel  = 0
ShareName    = MSSQLSERVER
RsFxVersion  = 0103
share|improve this question

3 Answers 3

I have encountered this problem before, and what solved it for us was using the command line tool to enable it from the command line. You can get the tool here.

share|improve this answer
    
Unfortunately, that's also failing. –  J. Pablo Fernández Jul 3 '09 at 17:59
up vote 0 down vote accepted

I had to re-install SQL Server, but if someone else is having the same problem, I'd recommend trying the other solutions first. Just don't have a lot of hope.

share|improve this answer
    
Re-installing Sql Server is definitely not the right way to go in this situation. –  Pawel Marciniak Mar 9 '10 at 17:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.