Setup failed for MSSQLSERVER. The following features are missing: FILESTREAM Fix the problems and re-run setup.Guy Burstein, in his blog, wrote that the STREAM support can be enabled using the following SQL command:
exec [dbo.sp_filestream_configure] @enable_level = 3;
I tried that and another error came in:
Once I executed the 3 lines together, I got the following confirmation message which, amusingly, still recommands me to run the RECONFIGURE statement even if I did that. Anyway better more redundant information than nothing…
Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'sp_filestream_configure'Checking my local installation of SQL Server Books Online, I found no track of sp_filestream_configure stored procedure, but I found that I can enable the STREAM support using sp_configure stored procedure as below:
EXEC sp_configure filestream_access_level, 2 RECONFIGURE GO
Once I executed the 3 lines together, I got the following confirmation message which, amusingly, still recommands me to run the RECONFIGURE statement even if I did that. Anyway better more redundant information than nothing…
Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
Happy coding!