Problem with R2 Training Kit-Can't find Adventure Works DB

Question

I installed the new training kit and the prereqs including the new AdWorksR2, which shows up in SSMS. However, when I go to the firsts Hands On Lab (Build Your First Web App with SQL Server and ASP.Net) the setup process tells me that Adventure Works is not installed. Does anyone have any suggestions about how to troubleshoot?

Thanks 

---

Dean MCTS-SQL 2005 Business Intelligence

Answer 1

Check that the db names haven't changed between versions.

Answer 2

I'm seeing the same problem. Database "AdventureWorks2008R2" is installed but the dependency checker (for the ATOM feeds HOL) says it isn't. This is on the January 2011 update of the training kit. I've got a named instance, not sure if this is confusing the checker.

Answer 3

same issue, searching for resolutions - did anyone ever find one, or at least have any suggestions? I'm using 2008 Express R2, also with named instances, and aren't really sure where to  start digging.

Answer 4

same issue, searching for resolutions - did anyone ever find one, or at least have any suggestions? I'm using 2008 Express R2, also with named instances, and aren't really sure where to  start digging.

Which training kit did you install?

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 5

If you are using SQL Server 2008 R2, download and attach the AdventureWorks2008R2 data file from http://msftdbprodsamples.codeplex.com/releases/view/59211. There is an mdf and SQL script option. For the mdf option, you will need to remove the log file from the list of files to attach. See Readme for Adventure Works 2008 R2 Sample Database for steps on how to install AdventureWorks2008R2 OLTP database.