filestream sql server 2008 R2 evaluation edition

Question

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.

Answer 1

I have run the exec sp_configure filestream_access level, 2

reconfigure

However,

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.

the problem remains

Answer 2

Hello,

Have you seen the following article?

http://technet.microsoft.com/en-us/library/cc645923.aspx   

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 3

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.

Answer 4

Hello,

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.

Regards,

Alberto Morillo
SQLCoffee.com