Installing the AdventureWorks Database

I've downloaded and installed the Adventure works database

I follow the instructions give here

http://msdn2.microsoft.com/en-us/library/ms310325.aspx

but this command here:

exec sp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

results in this error:

"unable to open physical file,................................................. the system can't find the specified file."

AdventureWorks_log.ldf + AdventureWorks_Data.mdf ...................don't exist at this location:

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

i'm thinking of reinstalling the whole adventure works DB.

any ideas please

Moving to the SQL Server Setup & Upgrade forum. This may not strictly be a setup problem, but this is probably the best place to start to make sure you have the sample database installed correctly. In any case, this is best suited for one of the SQL Server forums instead of .NET Data Access.

Thanks,
Sarah