Installing the Northwind Sample Database

To complete the LightSwitch Guided Tour lessons, you must download and install the Northwind sample database.

Install the Database

Download the Northwind and pubs Sample Databases for SQL Server 2000 from the Microsoft Download Center.
When prompted to run or save the file, click Save, and then select a file directory, such as C:\Temp.
In File Explorer, navigate to the directory where you saved the file and double-click SQL2000SampleDb.

The Microsoft SQL Server 2000 Sample Database Scripts wizard appears.
Click Next to continue.
On the License Agreement page, read the agreement, click I Agree if you agree to the terms, and then click Next.
On the Choose Installation Options page, click Next.
On the Confirm Installation page, click Next.
Respond to any prompts by accepting, and when the Installation Complete page appears, click Close.

The sample database is installed in the C:\SQL Server 2000 Sample Databases directory.
In File Explorer, navigate to the C:\SQL Server 2000 Sample Databases directory, right-click the instnwnd.sql file, and then click Edit.

The SQL script file opens in Notepad.

Replace the contents of the file with the following.

USE [master]
GO
CREATE DATABASE [NORTHWIND] ON
( FILENAME = N'C:\SQL Server 2000 Sample Databases\NORTHWND.MDF' )
 FOR ATTACH
GO

Save the file and close it.
From an elevated command prompt, switch to the C:\SQL Server 2000 Sample Databases directory and type sqlcmd –S .\SQLExpress –i instnwnd.sql.

The Northwind sample database will be installed in SQL Server Express and will be available for use from LightSwitch.