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 is the founder of Webucator (, a company that has provided training for tens of thousands of students from thousands of organizations. Nat started the company 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.

Follow Nat on Twitter at @natdunn and Webucator at @webucator.

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.