Mssql-docker: FileStream issue

[badcowlee]

Does the feature "filestream" support in winodws container? If so, how to do it?

Even I enable the filestream feature but the error "FILESTREAM feature is disabled" is still occured.

P.S (1) Both of the images 2016-sp1-windowsservercore-10.0.14393.1715 and 2017-windowsservercore-10.0.14393.1715 I have tried.

   (2) I used the attached file to enable the filestream feature

$instance = "MSSQLSERVER"
$wmi = Get-WmiObject -Namespace "ROOT\Microsoft\SqlServer\ComputerManagement13" -Class FilestreamSettings | where {$_.InstanceName -eq $instance}
$wmi.EnableFilestream(1, $instance)
Get-Service -Name $instance | Restart-Service

set-executionpolicy -executionpolicy unrestricted
Import-Module "sqlps" -DisableNameChecking
Invoke-Sqlcmd "EXEC sp_configure filestream_access_level, 2"
Invoke-Sqlcmd "RECONFIGURE"

enable.filestream.ps1.txt

Thank you!

[sogoth]

Tried the exact same thing before finding this issue. But i also changed logon user for the sql service to try with LocalSystem and an added administrator but nothing worked. Realy interesting problem and need to get this to work.

[badcowlee]

Well. Actually, I also change the service account of mssqlserver to local administrator but the the filestream still doesn't work.

[stephenwaskew]

Is there any progress with this issue? I am stuck here as well.

[ApolloCreek]

While migrating existing solutions, being able to use FILESTRAM feature on Windows based SQL server is mandatory for me. Hence, I'd like to know whether (soon) progress with this issue can be expected.
FILESTREAM needs to create a (SMB) share to work. A mssql container apperently does not have any file system shares nor were I able to create one with powershell.
Are issues with the shares the reason why FILESTREAM cannot be created?

[twright-msft]

@ApolloCreek - probably not "soon". We are going to start working on an improved Windows container in the next few weeks, but the focus there will be on packaging, making it smaller, fixing some known issues, etc. Not sure we are going to get to filestream right away.

[PatrickLang]

the "SERVER" service in Windows containers is disabled and won't work. FILESTREAM requires it, even when the files are stored locally. I think it's going to need a change in SQL to work right with local files

[cameron-pascal]

I've run into this as well. I tried enabling FILESTREAM the powershell way but AccessLevel in the WMI settings never changes from 0. I also tried this in C# by setting AccessLevel using the WMI interface provided by System.Management but that fails with HRESULT 2147944514: The Server service is not started As it is, I don't think its possible to get a SQL Server container running with FILESTREAM enabled. This is disappointing and hopefully it can be remedied soon.

[TheDutchDevil]

For us this is a blocking issue when it comes to the adoption of mssql-docker, we are heavily reliant on filestreams and are very interested in any updates regarding possible fixes for this problem.

[cameron-pascal]

@twright-msft Has there been any movement on this or is the status still the same?

[cameron-pascal]

@twright-msft Any idea if this was fixed?

[vin-yu]

@cameronmaxwell - this not yet supported on SQL Server containers.

[zeppelin4x]

@vin-yu @twright-msft Any idea if and when this will be supported? We are looking into utilizing SQL containers for our CI/CD pipelines, but this is preventing implementation.

[JonesMan1302]

Same problem here. Is there any workaround for this problem?

[mauruskuehne]

We could use FILESTREAM support as well. We'd like to simplify our development and testing environments with these images, but we need FILESTREAM support to run our application.

[phani-karne-sp]

Any update on this? We could also use FILESTREAM.

[schifazl]

We're also interested in this functionality, it would be very helpful

[klozowski]

+1 here. I had to dismiss MSSQL for Docker as a testing solution due to lack of FileStream support.

[amorelIM]

+1

[innov-sbouchard]

As a lot of other people here, we need FILESTREAM support in docker too.

[CarlHenrik]

Docker would be a great utility for our R&D, but lack of FILESTREAM is a deal breaker. We need FILESTREAM support.

[xiaoyao9184]

OK, No FILESTREAM support on windows and linux will lose advantage

[lkurylo]

Any progress with it?

[JulianCa]

Like many people here, we need FILESTREAM support.