Export (0) Print
Expand All

Northwind Database Installation

Visual Studio 2005

Some of the tutorials in this documentation show you how to display a Crystal report whose data configuration uses a programmatic logon to the Northwind database on a secure SQL Server.

These tutorials include the following:

In this section, you verify that you have installed the Northwind sample database that is provided with SQL Server or MSDE for use with these tutorials. Before you start, check the following:

  • If you use SQL Server, Northwind may already be installed. To verify this, check that Northwind is one of the databases installed on your system.
  • If you have just installed MSDE by following the instructions in the previous section, see the instructions in this section to install Northwind.
Visual Studio version Path to instnwnd.sql installer script
Visual Studio .NET 2002 C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Samples\Setup\instnwnd.sql
Visual Studio .NET 2003 Install a copy of the instnwnd.sql installer script to your file directory, by following the instructions in this section. See "To download the latest version of the instnwnd.sql installer script."
Visual Studio 2005 Install a copy of the instnwnd.sql installer script to your file directory, by following the instructions in this section. See "To download the latest version of the instnwnd.sql installer script."

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

  1. Go to the Microsoft SQL download website: http://www.microsoft.com/sql/downloads/.
  2. Locate the latest version of the Northwind database installer script (SQL2000SampleDb.msi).
  3. Download and run the SQL2000SampleDb.msi installer. That creates a copy of the instnwnd.sql installer script on your local hard drive in the following file directory:
    C:\Program Files\Microsoft SQL Server 2000 Sample Database Scripts\

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 in MSDE

  1. Go to the command prompt.
  2. Locate the Northwind installer script named instnwnd.sql (see table).
  3. 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
    Note   For [password], type the system administrator password that you created earlier in MSDE Installation with Windows or SQL Server Authentication.
  4. Press ENTER.

    The Northwind database installs.

    Note   The install process may take several minutes.

To verify the connection to the Northwind database

  1. Launch Visual Studio 2005.
  2. From the View menu, click Server Explorer.
  3. In Server Explorer, right-click Data Connections, and then click Add Connection...

    You can now test either Windows Authentication or SQL Server Authentication.

  4. If this is the first time you have added a connection in Visual Studio 2005 the Change Data Source window will appear. Select Microsoft SQL Server and click Continue.
    1. To test Windows Authentication, do the following:
    • Type the name of your MSDE server (typically your computer name).
    • Select the "Use Windows NT Integrated security" option.
    • Click the Select the database on the server dropdown list, and then select "Northwind."
    1. To test SQL Server Authentication, do the following:
    • Type the name of your MSDE server (typically your computer name).
    • Select the "Use a specific name and password" option.
    • Type the following user name: sa.
    • Type the system administrator password that you created earlier in MSDE Installation with Windows or SQL Server Authentication.
    • Click the Select the database on the server dropdown list, and then select "Northwind."
  5. Click Test Connection, to verify that your installation of Northwind with either Windows Authentication or SQL Server Authentication is successful.

If you have chosen to use SQL Server Authentication, for security you should not use the system administrator account. Instead, to address security concerns, create a database account with more limited access for use by your web application. In the following section you learn how to create this limited access account for addressing the Northwind database.

Continue to Security: Creating a Limited Access Database Account.

See Also

Security: Creating a Limited Access Database Account | What Needs to be Verified? | Setting Up the Development Environment

Show:
© 2014 Microsoft