💎SQL Reloaded: AdventureWorks requires FILESTREAM enabled

Surprises, surprises, surprises, programmers’ world is full of them! When you say that everything is ok, you just discover that something went wrong. I was expecting to have Adventure Works database installed though I haven’t checked that. I realized today that it’s missing, so I tried to reinstall it enabling this time the "Restore AdventureWorks DBs" feature, though I got another nice error:

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:

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!