The following features are missing FILESTREAM. Fix this problem and re-run setup.

Question

I have received SQL Server Enterprise Edition 180 day evaluation copy. When I attempt to install the sample database from the file  SQL2008.Reporting_Services.Samples.x86.msi the process runs to the very end and then gives the above error message and then deletes the entire installation. A search on the internet, help, on this site does not give meaningful answers to what "FILESTREAM" is so no troubleshooting can take place.

I have been working on this for 2 days

I am evaluating SQL Server 2008 to recomend an upgrade for a client and it is impossible to install the sample data. I have halted the upgrade plans untill we can resolve this issue. 2008 may be good but if we go to attempt to do a recovery from a crash and the system will not allow us to recover because of some new "feature" that gives us some "security" then we are toast. For the time being we will keep our servers on 2000 as it is stable.  You cannot call a program stable when 1/2 of the comments on the blog claim that they cannot install the sample data.

[e-mail]  [phone]

---

Tom Schiff

Answer 1

Hi Tom,

Are you familiar with SQL Server Configuration Manager?  In SSCM, right-click on your SQL 2008 service, and select properties.  On the FILESTREAM tab, check "Enable FILESTREAM for Transact-SQL Access", and then "Enable FILESTREAM for file I/O streaming access".  Restart your SQL 2008 instance and you should be fine.

Let me know how you fare.

---

Aaron Alton | thehobt.blogspot.com

Answer 2

Thank you Thank you  Aaron Alton. I went to SQL Server Configuration Manager (Never was there before) and lo and behold when I clicked help and typed in FILESTREAM I got a reply.

I did as you said and checked "Enable FILESTREAM" and clicked apply and that worked. Tried to add the Enable FILESTEAM for file I/O streaming and tried various things in the box that needs to be filled in it was suggesting "MSSQLSERVER" which it didn't like so I tried
local
localhost
Tom3
TOM3
it didn't like any of them Tom3 is the computer name

So I tried to install the MSI file one more time and it ran to the end of its run and hung. If I attempted to close the window it told me that it would uninstall. I Ctrl-ALT-Del and killed the process. Shut the machine down (power down). At power up all of the databases are there so I can get working.

Anyhow I can now get back to the book SQL Server 2008 Reporting Services so that I can prepare my presentation comparing Crystal Reports to MSSQL Server RS.

Progess Thank you again.

---

Tom Schiff