Adventureworks install error: No valid sql server instances are accessible for installation

Question

So I'm trying to install Adventureworks but it fails with the error above. It also says the problem could be due to SMO issues. So the server team installed the sdk which supposedly installs SMO. Still get same error. The only thing that was not installed is the Management Studio and related items. Could this be causing it or am I missing something else?

Answer 1

I have the same problem...

Answer 2

I also have the same problem!!!

Answer 3

Dido!

---

Keith Caravelli

Answer 4

Could you post the exact error message please?

---

Richard Douglas
Http://SQL.RichardDouglas.co.uk | @SQLRich

Answer 5

I am having this problem as well. I have SQL2008r2 Standard on a clean install of Win7Ult. Filestraming is enabled and so is full text search. I have added the user account being used to run SQL to all of the SQL usergrourps that are added after an install I have also give full admin rights to that user as well. This is the full text of the error I get after trying to intall adventureworks2008r2

 

Installation started at 11/23/2010 11:46 AM.

Copying scripts and CSV files to C:\Program Files\Microsoft SQL Server\100\Tools\Samples\.

Script copying succeeded.

No valid SQL Server instances are accessible for installation.  If instances are available the problem could be due to SMO issues.

Scripts and data are copied to C:\Program Files\Microsoft SQL Server\100\Tools\Samples\.  You can manually run the scripts from there.

See http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Installer%20Help%20for%20SQL%20Server%202008R2 for instructions.

Installation ended on 11/23/2010 11:46 AM.

 

UPDATE

I downloaded Adventureworks2008 SR4 and it worked with one minor problem. It reported that filestream was not enabled and I know that it is. It still installed and is working. I also had SSMS open while the install was running I don't know if that had any affect or not. Adventureworks 2008 SR4 can be found here 

http://msftdbprodsamples.codeplex.com/releases/view/37109

 

Answer 6

I got this same error when using SQL2008R2 and trying to install AdventureWorks2008r2. I gave up on that version of AdvertureWorks and downloaded AdventureWorks2008 SR4. You can get AdventureWorks2008 SR4 here http://msftdbprodsamples.codeplex.com/releases/view/37109 I also had SSMS running during the install this may or may not help I am still very new to SQL. 

Answer 7

Try going in the folder,( I think the folder is called Acventureworks OLTP 2008R2 or something like that),where the sample script is saved and double click on the file named instawdb. It should open up SSMS hit execute and you should be able to set up adventure works. Make sure you set  the parameters for the dB location and the location for all the CSV in the script you will need to uncomment the  two lines where you set the variables in the script . For the dB location its your choice and for the CSV files it is the same folder as your Adventureworks script is located in. Hope this helps

 

Cheers!

Answer 8

Thanks a lot IrfSmurf, your suggestions works great and now I have installed the AdventureWorks 2008 R2.  Thanks again! My very best regards, Sebastiao

---

Celso

Answer 9

I get the same problem. The installer just doesn't work. I'm sure you can work around it by installing scripts as per the other poster's suggestions- but I'd rather it just did it without breaking.

Answer 10

There was an issue with the 2008R2 SR1 samples database installer which should be fixed now.  Please download again and let me know if you are still having problems.

 

---

Bonnie Feinberg [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 11

Thanks...SR4 work perfectly for me and I was having lots of trouble with SR2 :-)

Answer 12

SR4 working perfectly...........................

http://msftdbprodsamples.codeplex.com/releases/view/37109