SqlSetup: Add FilesStreamLevel and FileStreamShareName properties

[NemoDima]

Please add new parametrs to SqlSetup

Description

Need ability to set FilesStreamLevel and FileStreamShareName

Proposed properties

FilesStreamLevel = [int] FileStreamShareName = [string]

Special considerations or limitations

FILESTREAMLEVEL [0..3]

Useful link: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15

Maybe it's possible to add together with https://github.com/dsccommunity/SqlServerDsc/issues/1481

[quillypowers]

Hah, I just ran into this. Since it looks like it never gained traction I'm using the computermanagementdsc and adding the registry modification below (applicable for sql 2016).

    Registry RegistrySqlEnableFilestream
    {
        Ensure      = "Present"  # You can also set Ensure to "Absent"
        Key         = "SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQLServer\Filestream"
        ValueType   = "Dword"
        ValueName   = "EnableLevel"
        ValueData   = "3"
    }

Then later SqlConfiguration for below - this one didn't work though...

    SqlConfiguration SQLFilestreamAccess
    {

        InstanceName   = 'MSSQLSERVER'
        OptionName     = 'filestream_access_level'
        OptionValue    = 2
        RestartService = $false
    DependsOn  = '[SqlSetup]DefaultInstance'
    }