Alomohora

In this section, you verify that you have installed the Northwind sample database that is provided with SQL Server 2005.

To download the latest version of the instnwnd.sql installer script

• Go to the Microsoft SQL download website: http://www.microsoft.com/sql/.

• Locate the latest version of the Northwind database installer script (SQL2000SampleDb.msi).

• Download and run the SQL2000SampleDb.msi installer.

You now have a copy of the instnwnd.sql installer script. Proceed to the next step procedure for installation instructions.

To install the Northwind database.

• Go to the command prompt.

• Locate the Northwind installer script named instnwnd.sql.

• From the command prompt, change directory to the path of the installer script. Type the following command to install the database.

osql -U sa -P [password] -i instnwnd.sql

• Press ENTER.

• The Northwind database installs.

To verify the connection to the Northwind database.

• Launch Visual Studio.

• And the final result like this: