Trying to Install AdventureWorks in SQL 2005

I went to Microsoft downloads and downloaded the AdventureWorks.msi file.
When it ran, it says that it installed AdventureWorks.

I think I have SQL 2005 Express and SQL 2005 on my PC. There are two
directories: C:\Program Files\Microsoft SQL Server\MSSQL\Data
and C:\Program Files\Microsoft SQL Server\MSSQL.1\Data

The AdventureWorks has been placed in the C:\Program Files\Microsoft SQL
Server\MSSQL.1\Data directory, but when I bring up SQL Server Management
Studio, I don't see AdventureWorks. The databases I have associated with
this are all under the C:\Program Files\Microsoft SQL Server\MSSQL\Data
directory.

How can I import the table into SQL server and why did the MSI install put
it in the wrong place.

Thanks for any guidence and help on this "day before Thanksgiving"



.

Relevant Pages

  • Re: Got an Exception error - still
    ... it looks to me like you are trying to attach the adventureworks database which is made for sql2005 with sql2000, ... I tried using Enterprise Manager for SQL 2000. ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL 2005 SP1 Database Mirroring
    ... Die Dienste SQL Server, SQL Server Agent und SQL Server Browser werden mit ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ...
    (microsoft.public.de.sqlserver)
  • Re: Got an Exception error - still
    ... I uninstalled the AdventureWorks from the the control panel then I ... I tried using Enterprise Manager for SQL 2000. ... Could not open new database ... install put it in the wrong place. ...
    (microsoft.public.sqlserver.setup)
  • Re: Got an Exception error - still
    ... Have you considered that perhaps your copy of the Adventureworks files are ... Most good judgment comes from experience. ... CREATE DATABASE is aborted. ... I think I have SQL 2005 Express and SQL 2005 on my PC. ...
    (microsoft.public.sqlserver.setup)
  • Re: How to access database in SQL 2005
    ... Did you try to attach the AdventureWorks mdf and log.ldf files by following ... Please read the topic "Reinstalling Sample Databases ...
    (microsoft.public.sqlserver.setup)
Loading