Installation Button for AdventureWorks SQL Server 2008 R2 greyed out. Suggestions welcome

Question

Afternoon all,

I'm hoping that you'll be able to help me progress with the Installation of the Adventure Works samples as I've hit a brick wall.  My current set up: -

Windows Server 2008 R2 64bit
SQL Server 2008 R2 64bit
Fully patched and updated.

I'm wanting to install the SQL Server R2 version and have followed the steps to install FileStream and Full-Text Search.  I've rest the SQL Instance and run the AdventureWorks Installer.  I'm advised that the AdventureWorks OTLP R2 component that required FileStream can now install but the installation button is fully greyed out.

At which point, I'm at a loss.  Any suggestions, comments, questions etc. are welcome.

---

http://www.final-exodus.net

Answer 1

I had a similar issue many moons ago and had to retrospectively install the filestream component.

You'll need to check that it is enabled and configured, unfortunately you have to do this in two different places:

Right click on the server and choose properties.
In the Properties window click on the advanced option.
FileStream Access Level is the very first option - set it according to your needs. I chose full access as it was a local install.

Next thing is to check how it is configured so you will need to run the stored procedure sp_configure:

exec sp_configure 'filestream access level',2 --2 being full access
reconfigure;
exec sp_configure

Rich

Answer 2

This worked perfectly also found that the installer wouldn't process an installation if the directory for the Analysis Services scripts didn't actually exist.

---

http://www.final-exodus.net

Answer 3

Hi,

 

I followed the your instructions, but i'm still getting greyed out. :(

 

any advise?

having exams soon. i need a environment for study urgently... :(

Answer 4

I initially had this problem, but then I chose another installation folder which made the install button to be enabled.

 

Tim.