When installing the sample databases on a SQL Server 2008 R2 installation i ran into an issue with FILESTREAM settings. You can download the Sample databases at the codeplex site and many other great stuff. When installing, i saw that the AdventureWorks OLTP 2008R2 couldn't be installed.
At first the webpage told me that you have to configure the FILESTREAM. Okay i did:
EXEC sp_configure filestream_access_level, 1
After that i tried it again. No go.
Than, somewhere on the page i saw a link to another page which linked to another page, etc which told me to set a check at the checkbox "enable FILESTREAM for Transact- SQL access" at servicewindow of the SQL Server service. You can reach this at the configuration manager:
You can do this with the following steps:
1.On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
2.In the list of services, right-click SQL Server Services, and then click Open.
3.In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
4.Right-click the instance, and then click Properties.
5.In the SQL Server Properties dialog box, click the FILESTREAM tab.
6.Select the Enable FILESTREAM for Transact-SQL access check box.
And the results are:
You have to install the analysis databases seperately in BIDS.