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).
Note
Microsoft recommends Integrated Security as the most secure approach.
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/