Saturday, November 24, 2012 1:59 PM
I have downloaded and installed the above edition in an attempt to learn sql server. I have purchased the microsoft step by step. However, I am unable to begin the lessons because I am unable to enable filestream either through the sp_configure command or the configuration manager. I did enable during install. In fact, there is no filestream tab displayed in configuration manager at all. I have the 64-bit installed. Any assistance would be so greatly appreciated. Thank you in advance.
Saturday, November 24, 2012 2:05 PM
I have run the exec sp_configure filestream_access level, 2
Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
the problem remains
Saturday, November 24, 2012 8:08 PMModerator
Hope this helps.
Sunday, November 25, 2012 5:40 PM
This link put all troubleshooting in a nutshell but still did not fix the problem. I have ensured my install is the 64 bit version. My version is 10.50.2500.0 and best guess is it is sql server express edition. I have run all suggested queries and serverproperty remains 0 (not enabled). Filestream Tab just simply does not appear in the Configuration Manager. Right clicking on my instance and properties shows Fielstream to be T-sql enabled. One thing that remains a quandry is under service components the Microsoft.net started is 32-bit and when I try to stop and start the 64-bit version I get "The Microsoft.Net Framework NGEN v4.0.3019_x64 service on Local Computer started and then stopped. Some servicese stop automatically if they are not in use by other services or programs." I did this secondary to reports filestream is not enabled on 32-bit version running on 64-bit machine. I have a multitude of request for help regarding this issue with no answer that has worked for me. Any assistance will be so greatly appreciated.
Sunday, November 25, 2012 11:27 PMModerator
You cannot enable Filestream on a 32-bit SQL Server instance when is installed on a 64-bit operating system. This is by design.
Try to install a 64-bit instance of SQL Server on that operating system.
Hope this helps.