AdventuresWork Database
I downloaded the Adventureworksdb.msi. I ran the msi file. It seemed to install but I do not see the database on my computer or in SQL Server. Where is the database? How do I get it to display in SQL Server?
MrAli
AdventureWorks MSI will create the MDF/NDF files in the folder it unpacks to. Go to SQL Server, right click on Databases, go to 'attach' and select the MDF file. At that point, you will have it attached to your SQL server!
ASKER
It is not at the location where i ran the MSI file. I searched for MDF files and I cannot find AdventureWorks.mdf on my computer.
It looks like they changed the process.
I went to:
http://msftdbprodsamples.codeplex.com/releases/view/55926
Clicked the MSI file and it went to install the files to :
C:\Program Files\Microsoft SQL Server\100\Tools\Samples
I clicked install after verifying the INSTANCE, making sure it's the one I connect to. Once this one installed, I was able to log in to my server and saw the AdventureWorks databases. Please try with the above link.
I went to:
http://msftdbprodsamples.codeplex.com/releases/view/55926
Clicked the MSI file and it went to install the files to :
C:\Program Files\Microsoft SQL Server\100\Tools\Samples
I clicked install after verifying the INSTANCE, making sure it's the one I connect to. Once this one installed, I was able to log in to my server and saw the AdventureWorks databases. Please try with the above link.
ASKER
I don't have a Samples folder and I downloaded Adventureworks 2005.
What link did you use? If you have SQL 2008, I would recommend using the link I sent you and completely ignore the 2005 samples.
ASKER
I instaled SQL Server 2005 client on my computer. I downloaded the database from here http://codeplex.com/SqlServerSamples
ASKER
Sorry - from here -> http://msftdbprodsamples.codeplex.com/releases/view/4004
According to the link:
http://sqlserversamples.codeplex.com/
It states:
"Note: This is one monolithic set of all Microsoft SQL Server product samples (except for the sample databases, due to size constraints) and does NOT include any community projects. If you are interested in a specific subject area, links to download individual technology-focused samples are below."
After reading through the text I clicked on the link for the MS Sample DBs and it took me to :
http://msftdbprodsamples.codeplex.com/releases/view/55926
It's a 82mb download. Install this and you'll have the right file. According to the site, what you downloaded doesn't include the sample databases
http://sqlserversamples.codeplex.com/
It states:
"Note: This is one monolithic set of all Microsoft SQL Server product samples (except for the sample databases, due to size constraints) and does NOT include any community projects. If you are interested in a specific subject area, links to download individual technology-focused samples are below."
After reading through the text I clicked on the link for the MS Sample DBs and it took me to :
http://msftdbprodsamples.codeplex.com/releases/view/55926
It's a 82mb download. Install this and you'll have the right file. According to the site, what you downloaded doesn't include the sample databases
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I figured it out. I downloaded the wrong verions of the dbase. I needed to download the 64 bit version. I was able then to find the dbase. Thanks for helping me troubleshoot it. I'll award points for your help.
TY for the reply