Why can I not select a local database instance fo AdventureWorks2008?

Question

Hi,

First of all I installed the 2008 AdventureWorks Database Refresh 3 Samples and everything seemed to install fine. However the database did not exist within my local SQLExpress instance, so I looked at the prerequisites and realised I was missing most of them (installer really should have failed but oh well).

I then upgraded my local SQLExpress instance to 2008 with Advanced Services. I installed Full-Text Search and also enabled FILESTREAM.

Then I removed the installation of 2008 AdventureWorks Database Refresh 3 Samples since it wont let me repair or upgrade and tried to start again. Now when I install, after I select the features and it asks which local instance to use I select "SQLEXPRESS (engine)" and it wont let me click Next.

Why wont it let me click Next?

Answer 1

Hello the_steiny,

I have met this annoying problem.
But i found a solution : return to the preceeding page ( <<) and click on >> : you will have access to the button Next

I hope this post will help you

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

Hi,

Thanks for that Papy. Unfortunately I have already tried that. When I go back then forward then click next the installer throws an error with no error codes what-so-ever. Says something about ending prematurely.

Cheers

Answer 3

Hi the_steiny,

I had the same problem - I found two workarounds that worked for me.

You can try installing the databases manually by downloading the .zip version and using the installer .sql scripts with SQLCMD.

The other workaround (but I don't think this is possible with SQL Express) is to install SSIS, SSAS, SSRS.  In my case, this then let the installer run successfully - I think it hinged on SSAS being installed but I had installed all three together so can't be certain without further testing.

I've put details of both here http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/0acd6be6-accd-4d62-a97e-4826c272fed4 and logged it as an issue in the Issue Tracker.

I hope this helps!

Thanks,
Simon