2

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
Pablo
  • 7,249
  • 25
  • 68
  • 83

3 Answers3

0

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.

Sam Cogan
  • 38,158
  • 6
  • 77
  • 113
0

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=473895 talks about this hotfix.

Does that help?

Preet Sangha
  • 2,727
  • 1
  • 24
  • 25
0

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.

Pablo
  • 7,249
  • 25
  • 68
  • 83