Home / server / Questions / 35452
Accepted
Pablo
Asked: 2009-07-03 23:14:05 +0800 CST

Enabling filestream on SQL Server 2008

  • 772

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
sql-server-2008 filestream

3 Answers

  1. 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.

    • 0
    • 0
  3. Best Answer

    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.

    • 0