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