Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Problem with R2 Training Kit-Can't find Adventure Works DB

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

  • Saturday, July 24, 2010 10:30 AM
     
     
    Sign In to Vote
    0

    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
     

All Replies

  • Monday, October 25, 2010 1:00 PM
     
     
    Sign In to Vote
    0
    Check that the db names haven't changed between versions.
     
  • Friday, May 27, 2011 1:42 PM
     
     
    Sign In to Vote
    0
    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.
     
  • Sunday, February 26, 2012 4:25 PM
     
     
    Sign In to Vote
    0
    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.
    • Edited by StevenVore Sunday, February 26, 2012 4:26 PM
    •  
     
  • Wednesday, March 14, 2012 2:28 AM
    Moderator
     
     
    Sign In to Vote
    0
    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

     
  • Friday, June 15, 2012 4:20 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    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.