Problem:
I'm trying to enable FILESTREAM for SQL Server 2022 running inside a Docker container, but I'm encountering issues. Since I am using SQL Server 2022 in a container, I don't have access to SQL Server Configuration Manager. As a result, I need to find an alternative way to enable FILESTREAM.
For context, I installed SQL Server 2022 Developer Edition in a Server Core 2019 container (Windows Container). I am now trying to enable FILESTREAM on SQL Server 2022 running in a windows container. Even using a Windows container, I still continue to have trouble enabling FILESTREAM.
If anyone has any advice on how to correctly enable FILESTREAM for SQL Server 2022 in a Windows Docker container, it would be greatly appreciated.
What I've Tried:
I've tried to enable FILESTREAM several different ways including:
- Powershell.
- Configuring a config file (.ini) for headless SQL Server installs.
- Using SQL Server Management Studio.
No matter what I do, whenever I try to restore a FILESTREAM database I receive an error saying "FILESTREAM feature is not enabled".