Configured values different to Running values, even after full restart I am trying to change the FILESTREAM Access Level property on a SQL Server Express database. The Configured values section of the Advanced tab of my Server Properties dialogue box looks like so:



The Running values section looks like this:



This is before and after a full restart of the computer. Am I right in thinking that SQL Server Express just doesn't support this option, or could there be another reason this is happening?

Thanks
Jakub Hromadík originally wrote in a comment:


  This just happened to me. No matter what I did, the running value was always Disabled. What finally did it for me was repairing the SQL Server installation. I'm running SQL Server 2016 SP1


This also worked for me.

Note also:

From the documentation, filestream access level Server Configuration Option


  Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled


and be sure to follow all the steps in How to: Enable FILESTREAM