MSDE Installation with Windows or SQL Server Authentication

Some of the tutorials in this documentation show how to display a Crystal report whose data configuration requires a programmatic logon to a secure SQL database.

These tutorials include the following:

• Tutorial: Logging onto a Secure SQL Server Database
• Tutorial: Logging onto a Secure SQL Server Database Using SQL Authentication
• Tutorial: Logging onto a Secure SQL Server Database Using Integrated Security
• Reduced-Code Secure Database Logon in a Web Site
• Tutorial: Connecting to IDataReader

To work with these tutorials, you need Microsoft SQL Server (or its free version, MSDE) installed and configured with either Windows Authentication (if you wish to use Integrated Security) or SQL Server Authentication (if you wish to use SQL Security).

• If you already have Microsoft SQL Server or MSDE installed with either Windows or SQL Server Authentication, proceed to Northwind Database Installation to verify that the sample database "Northwind" is installed.

• If you do not have either server installed, this section shows you how to install MSDE with Windows or SQL Server Authentication.

  Note

  To configure your project to connect to Oracle or other SQL database servers, see the knowledge database at: https://technicalsupport.businessobjects.com/

In this section:

• Installing MSDE Release A from the Microsoft web site

• Northwind Database Installation

• Security: Creating a Limited Access Database Account