SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.
After installing sample databases the second most asked question is WHERE IS NORTHWIND?
Northwind database was the best sample database for SQL Server 2000. Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005. MSDN Book On Line (BOL) uses the AdventureWorks in all of their examples and it makes it easy to follow up if a proper understanding of AdventureWorks schema is developed. However, SQL Server Compact Edition uses Northwind as a sample database.
If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.
My recommendation: Start getting familiar with AdventureWorks.
UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using images.
Reference : Pinal Dave (https://blog.sqlauthority.com)
70 Comments. Leave new
It is under the releases tab here:
https://archive.codeplex.com/
Hi
I am using sql 2005 Dev ver 9 and I need to know how to create a database on my local hard drive. Wont allow me since it defaults connection to my network. I need to create a database on my hard drive when I am not connected.
Please help.
thanks
James
Recently, I wanted to populate some sample databases in my fresh 2008 environment on Vista. I hit a couple snags, so this post may be useful for the community.
Thanks for the guidance!
heres where to get the sample database:
The MVC Framework for .net uses Northwind.
This is very helpful for me.. Thanks a lot..
Great info – thank you!
-Paul Smietan
Clicked your AdventureWorks link and the first .msi file of the second link, I downlloaded the AdventureWorksDB.msi to my database server machine.
https://archive.codeplex.com/
I downloaded the AdventureWorks.msi to a C: folder with Master DB and a e: folder with user DB.
Running AdventureWorks.msi from either folder, received the “not a valid installation package for the product AdventureWorkDB” error message.
Why? Different SQL 2005 version has different AdventureWorks package?
Hi Friends,
I wonder if any of you can help. I tried downloading AdventureWorksLT from http://www.codeplex.com but the site does not work. After clicking on file to downlaod and clicking on I Agree button nothing happens?!
i am trying to work in sql server 2005, i want some sample data base other than the tarditional northwind and puds database. And also some please give me some ebooks so that i can learn the SQL querys very fast..
I have downloaded adventureworks Db .But now i Can not see thayt in the Studios.What to Do .Also tell me if there is a good tutorial for learning Stored procedures.Thanks
Thanks for this information,i was loooking for these information for longtime…thanks
Seems like AdventureWorks only is supported by SQL Server 2008 now…
see this error message (running SQL Server 2005 from inside of Visual Studio 2008 under Vista):
—————————
Microsoft Visual Studio
—————————
The database ‘C:\USERS\USER\DOCUMENTS\ADVENTUREWORKS 2008 LT\ADVENTUREWORKSLT2008_DATA.MDF’ cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database ‘C:\USERS\USER\DOCUMENTS\ADVENTUREWORKS 2008 LT\ADVENTUREWORKSLT2008_DATA.MDF’. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Users\USER\Documents\AdventureWorks 2008 LT\AdventureWorksLT2008_Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
—————————
OK
—————————
Hi
I am using sql 2005 ver 9 and I need to download northwind in my database but I dont have it and I dont know how can I install it in my sql server please help me
i have downloaded adventureworksdb.msi and installed successfuly.as well as i have attached that database also.
when i try to write query using any tables from adventureworks it gives me following error
‘ Invalid Object Name’
Can any on pls guide me about this ?
how to get rid of this error.
If you get the solution of your problem plz forward me the solution because having same problem i am facing with sql 2005 Adventureworks DB.
Thank you
I successfully installed AdventureWork Database , but I just can’t open the diagrams. The error “does not have a valid owner”…. I went to Files page on the Database Properties dialog box and there is not owner, but does not let add one… What it can be?…. Any help it will be greatly appreciate!!!
Thanks!!!
Cristobal.
@Rama,
you can insert muptiple rows b using UNION All is SQL SERVER2005
Thank you It is very helpful
i have downloaded adventureworksdb.msi and installed successfuly.as well as i have attached that database also.
when i try to write query using any tables from adventureworks it gives me following error
‘ Invalid Object Name’
Can any on pls guide me about this ?
how to get rid of this error.
@Chetan
Can you please tell us what is the query that you are executing.
Execute this command and check what it returns.
Script:
Select Db_Name() as DatabaseName
When you run above script, this should return adventureworks as output, this means, you are connected to right database. Other wise, you need to run below script before you run your query
Use adventureworks
go
execute your query.
If this does not solves your issue, please share with us your query that gives you error. and also please post complete error message. This would help us resolve your issue quickly and accurately.
~ IM.
Can I get SalesDB & Vendor database scripts, their .mdf & .ldf files??
Can u plz send me it in my email ID?
Hi
I am using sql 2005 and I need to download Adventure/northwind in my database but I dont have it and I dont know how can I install it in my sql server please help me