Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

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?
0
CipherIS
Asked:
CipherIS
  • 6
  • 5
1 Solution
 
MrAliCommented:
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!
0
 
CipherISAuthor Commented:
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.
0
 
MrAliCommented:
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.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
CipherISAuthor Commented:
I don't have a Samples folder and I downloaded Adventureworks 2005.
0
 
MrAliCommented:
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.
0
 
CipherISAuthor Commented:
I instaled SQL Server 2005 client on my computer.  I downloaded the database from here http://codeplex.com/SqlServerSamples
0
 
CipherISAuthor Commented:
0
 
MrAliCommented:
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
0
 
MrAliCommented:
Ok from your updated link I clicked on:
AdventureWorksDB.msi which directly linked to:
http://msftdbprodsamples.codeplex.com/releases/view/4004#DownloadId=11753

Right after hitting 'i accept' it gave the verbage:
Install AdventureWorksDB to:
C:\-longpath-\data

I hit next next install.  Whatever path it gives you on that screen is where you'll find the data files.  I already have 'adventureworks' installed from the link I presented earlier so it didn't overwrite anything.  Consider the 2008 DB sample, it should still work on 2005, and also, consider upgrading SQL 2005 to at least 2008 or 2008R2.  MS is almost releasing SQL 2012 shortly.
0
 
CipherISAuthor Commented:
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.
0
 
MrAliCommented:
TY for the reply
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now