How to Install Northwind on SQL Server

  • google plus

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.

Take our Introduction to SQL Training course for free.

See the Course Outline and Register


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.

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, XML, Windows, Java, Adobe, HTML5, JavaScript, Angular, and much more. Check out our complete course catalog.



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.