Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Log & Event Manager (LEM) > LEM - Knowledgebase Articles > Change the database connection

Change the database connection

Table of contents
Created by Interspire Import, last modified by Jessica Solis on Aug 14, 2018

Views: 1,706 Votes: 0 Revisions: 10

Updated Jan 19, 2018

 

1. Open Crystal Reports and create a new Report.
2. Click Database > Log On or Off Server.
3. Expand Create New Connection in the Data Explorer window and double-click JDBC (JNDI).
4. In the JDBC (JNDI) window, enter the information for the Connection URLDatabase Class Name and Connection Name fields. Click Next.

changing the database connection - 1.png


5.  On the JDBC (JNDI) Connection Information screen, enter the following credentials:

User ID field - contego
password field - reports 

The following are credentials that are needed for the Database connection:

a. LEM 6.0.0 and earlier:
User ID field - contego 
password field - reports 

b. LEM 6.0.1 and later:
Specify credentials of LEM Web/Air Console user with Reports, Administrator or Auditor role. If there is a Database field, enter alertdb in it.

changing the database connection - 2.png


6. Click Finish, and then click Close

7. Use Database > Database Expert to add tables to the report when the database connection is complete.

changing the database connection - 3.png.jpg

8. The reports are ready after the relevant tables are selected in the Database Expert and their references within the report are moved from AlertDBDSN to HSQLDB.

Last modified

Tags

Classifications

Public