7.5 Installation

This topic provides the Crystal Reports Server installation instructions for the following:

7.5.1 Installing Microsoft Internet Information Server (IIS) and ASP.NET

If the IIS and ASP.NET are not installed on your Sentinel 6.1 server, use the following procedure to install. You might need the Windows Server 2003 installation CD to add these Windows components.

  1. On the Windows desktop, go to Control Panel > Add/Remove Programs.

  2. In the left pane, click Add/Remove Windows Components.

  3. Select Application Server.

  4. Click Details.

  5. Select ASP.NET and Internet Information Services (IIS).

  6. Click OK.

  7. Click Next.

  8. (Conditional) If you are prompted for the Windows Server 2003 installation CD, insert it into the CD drive.

  9. Click Finish.

  10. Continue with one of the following sections:

7.5.2 Installing Crystal Reports Server for SQL Server 2005 with Windows Authentication

  1. Install SQL Server 2005 in mixed mode.

  2. Launch Microsoft SQL Server Management Studio.

  3. In the navigation pane, expand Databases.

  4. Right-click Database, then select New Database to create the Crystal CMS database.

  5. In the Database name field, specify BOE115 and click OK.

  6. Exit Microsoft SQL Server Management Studio.

  7. Insert the Crystal Reports XI R2 Server CD into the CD-ROM drive.

  8. If Autoplay is enabled on your machine, the installation begins. Continue with Step 9.

    or

    If Autoplay is disabled on your machine, run setup.exe and follow the prompts.

  9. Select the Crystal Reports setup language.

  10. In the Select Client or Server Installation window, select Perform Server Installation.

  11. Specify the Crystal license key that you received from the Novell Customer Center.

    Novell provides two Crystal license keys, one for Crystal Reports Server and the other for the Crystal Reports Developer (to modify or create new reports). Ensure that you use the Crystal Reports Server key when installing Crystal Reports Server.

  12. Specify a destination folder.

  13. For the install type, select Use an existing database server.

  14. In the CMS Database pane, click Browse.

  15. Click the Machine Data Source tab, then click New.

  16. Select System Data Source, then click Next.

  17. Scroll down and select SQL Server, then click Next.

    A new source displays.

  18. Click Finish.

  19. Right-click Databases, then select Create New Database.

  20. In the New Data Source to SQL Server window, specify the name of your data source (for example, BOE115) and an optional description.

  21. For Server, click the down-arrow and select (local), then click Next.

  22. Ensure that With Windows NT authentication using the network Login ID is selected, then click Next.

    The Login ID that is displayed in this window is your Windows login name.

  23. Select the Change the default database to check box. Change your default database to BOE115, then click Next.

  24. In the Create a New Data Source to SQL Server window, click Finish.

  25. Click Test Data Source and test the data source. After testing the data source, click OK.

  26. In the Select Data Source window, select the new data source (BOE115) and follow the prompts until you get to the SQL Server Login. Ensure that Use Trusted Connection is selected, then click OK.

    The Login ID that is displayed in this window is your Windows login name.

  27. In the Web Component Adapter Type window, select IIS ASP.NET.

    If you have not installed IIS and ASP.NET through Control Panel > Add Remove Programs > Add/Remove Windows Components, IIS ASP.NET is disabled.

  28. After installation, change the login account for Crystal Reports Page Server and Crystal Reports Job Server to the Sentinel Report User domain account:

    1. Click Start > Programs > BusinessObjects > Crystal Reports Server > Central Configuration Manager.

    2. Right-click Crystal Reports Page Server, then select stop.

    3. Right-click Crystal Reports Page Server again, then click Properties.

    4. In the Log On As pane, deselect the System Account, specify the Sentinel Report User domain account username and password that was used for the Sentinel Report User during your Sentinel install, then click OK.

  29. Right-click Crystal Reports Page Server, then click start.

7.5.3 Installing Crystal Reports Server for SQL Server 2005 with SQL Authentication

  1. Complete Step 1 through Step 20 in Section 7.5.2, Installing Crystal Reports Server for SQL Server 2005 with Windows Authentication.

  2. When you are prompted for an authentication method, select With SQL Server authentication.

  3. Specify the Login ID as sa and specify a password, then click Next.

  4. Select Change the default database to. Change your default database to BOE115, then click Next.

  5. In the Create a New Data Source to SQL Server window, click Finish.

  6. Click Test Data Source, then click OK.

  7. In the Select Data Source window, select BOE115 and continue to click OK until you get to the SQL Server Login window.

  8. Ensure that Use Trusted Connection is not selected. Click OK, then click Next.

  9. In the Web Component Adapter Type window, select IIS ASP.NET.

    If you have not installed IIS and ASP.NET through Control Panel > Add Remove Programs > Add/Remove Windows Components, IIS ASP.NET is disabled.

Configuring Open Database Connectivity (ODBC)

This procedure sets up an ODBC data source name to allow Crystal Reports Server to connect to the Sentinel database on Windows and SQL Server. These steps must be performed on the Crystal Reports Server machine.

  1. On the Windows desktop, go to Control Panel > Administrative Tools > Data Sources (ODBC).

  2. Click System DSN, then click Add.

  3. Select SQL Server, then click Finish.

    A window displays prompting for driver configuration information.

  4. Specify the following information:

    Data Source name: The default data source name is esecuritydb

    Description: Description of the data source (optional)

    Server: Host-name or the IP address of the Sentinel server

  5. Click Next.

  6. Select how SQL Server should verify the authenticity of the login ID:

    For Windows NT Authentication: Select With Windows NT authentication using the network Login ID

    The Login ID that is displayed in this window is your Windows login name.

    For SQL Authentication: Select With SQL Server authentication using a login ID and password entered by the user, specify the Login ID as esecrpt, then provide a password.

  7. Click Next.

  8. In the next window, select Change the Sentinel database (Default name is ESEC), and leave all the other settings as the defaults.

  9. Click Next, then click Finish.

  10. Click Test Data Source. After testing, click OK until you exit.

7.5.4 Installing Crystal Reports Server for Oracle

  1. Insert the Crystal Reports XI R2 Server CD into the CD-ROM drive.

  2. Select the Crystal Reports setup language.

  3. In the Select Client or Server Installation window, select Perform Server Installation.

  4. Select Use an existing database server.

    The CMS Database Information window displays.

  5. Select SQL Server (ODBC), then click Browse to select a DSN.

  6. After you select a DSN, you are prompted for a username and password. Specify the required information and click Next.

    Crystal Reports Server and SQL Server 2005 must reside on the same machine.

  7. Select IIS ASP.NET.

    If you have not installed IIS and ASP.NET through Control Panel > Add Remove Programs > Add/Remove Windows Components, IIS ASP.NET is disabled. Installing IIS and ASP.NET is a prerequisite to this installation.

  8. Select SQL Server authentication.

    The Crystal Reports Server supports direct access to a Sentinel database on Oracle. This accessibility is provided by the crdb_oracle.dll translation file. This file communicates with the Oracle database driver, which works directly with Oracle databases and clients, retrieving the data you need for your report.

Installing and Configuring Oracle Client Software

NOTE:In order for Crystal Reports Server to use Oracle databases, the Oracle client software must be installed on your system, and the location of the Oracle client must be in the PATH environment variable.

When installing Oracle Client, perform the following:

  • Accept the default install location.

  • Select No for Perform Typical Configuration.

  • Select No for Directory Service.

  • Select Local.

  • Specify the TNS Service Name as ESEC.

  • (Optional) Specify the Username (optional) as esecrpt.

After the installation, create a local Net Service Name configuration.

The following procedure is for the Oracle native driver, but the procedure should be similar for Oracle 10.

To create Net Service Name configuration for an Oracle native driver:

  1. Select Oracle-OraHome92 > Configuration and Migration Tools > Net Manager.

  2. In the navigation pane, expand Local and select Service Naming.

  3. Click the plus sign on the left to add a Service Name.

  4. In the Service Name window, specify the Net Service Name as ESECURITYDB, then click Next.

  5. In the Select Protocols window, select TCP/IP (Internet Protocol), then click Next.

  6. Specify the hostname or IP address of the machine that has the Sentinel database.

  7. Select the Oracle port (the default 1521 on install), then click Next.

  8. Identify the Sentinel database or service:

    1. Select (Oracle8i or later), specify the Service Name (this is the Oracle instance name).

    2. For connection type, select Database Default.

    3. Click Next.

  9. In the Test window, click Test, then click Next.

    The test might fail because the test uses a database ID and password.

  10. If the test fails:

    1. In the Connection Test window, click Change Login.

    2. Specify the Sentinel Oracle ID (use esecrpt) and password then click Test

  11. If the test fails again:

    1. Ping the Sentinel Server.

    2. Verify that the hostname of the Sentinel Server is in the hosts file on Crystal Reports Server. The hosts file is located at %SystemRoot%\system32\drivers\etc\

  12. Click Close, then click Finish.