How to Install Northwind on SQL Server

In Brief...

Northwind was originally created as a sample database for Microsoft Access. Microsoft also included it with SQL Server 2000. Although later versions of SQL Server did not include the Northwind database, you can easily install it.


To install the Northwind sample database on SQL Server:

  1. If you're taking a class with us, you will find a Northwind-SQLServer.sql file in your class files. It will be located either in the Webucator/ClassFiles or the Webucator/ClassFiles/Setup directory.
  2. Open Northwind-SQLServer.sql in SQL Server Management Studio.
  3. Press the F5 key to execute the script.
  4. Test by typing the following and the press F5:
    SELECT * FROM Employees;

If the test is successful, you should see a listing of employees including a Nancy Davolio.

If you are not taking a SQL class with us, you can download and run SQL2000SampleDb.msi from Microsoft.

Author: Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for web development with his business expertise and to help companies benefit from both.