• google plus

How to Install Northwind on SQL Server

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 technical training with his business expertise and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a BA in International Relations from Pomona College.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.