Solved

SQL 2005 Failure Audit When Running Crystal 10 Reports

Posted on 2008-09-29
12
402 Views
Last Modified: 2012-05-05
SQL 2005 database records this error message whenever running Crystal Reports -- reports run fine:

Event Type:     Failure Audit
Event Source:   MSSQLSERVER
Event Category: (4)
Event ID:       18456
Date:           9/29/2008
Time:           12:25:44 PM
User:           N/A
Computer:       NAMEY
Description:
Login failed for user 'validaccountname'. [CLIENT: 172.21.0.111]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 06 00 00 00 52 00 4f 00   ....N.A.
0010: 43 00 4b 00 59 00 00 00   M.E.Y...
0018: 07 00 00 00 6d 00 61 00   ....m.a.
0020: 73 00 74 00 65 00 72 00   s.t.e.r.
0028: 00 00                     ..      
NOTE: I've changed some of the names in this sample, but the error remains valid.  The error type is "password mismatch"
0
Comment
Question by:sneeman759
  • 7
  • 5
12 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22600967
How are you calling the report?

mlmcc
0
 

Author Comment

by:sneeman759
ID: 22601241
Database connection established during report creation using OLE DB (ADO), SQLOLEDB.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22601761
Are you getting this from the Crystal designer or when you call Crystal from an application?

mlmcc
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:sneeman759
ID: 22602350
Both.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22602612
Even with the error, the report shows what it is supposed to?

Do you have a table in the report you aren't using?

mlmcc
0
 

Author Comment

by:sneeman759
ID: 22603923
All reports reflect correct data.  They originally pointed to a SQL 2000 database.  This database was migrated to SQL 2005 on a different server.  I edited each report to use the new data source.

The only difference between the two databases: the db account password was changed between the two databases.

Is there embedded information within the report that's not getting reset?
0
 

Author Comment

by:sneeman759
ID: 22603988
FYI: I created a new report from scratch using the same connection information.  No errors.

I hope this doesn't mean I must recreate every report (over 100).  When I modified the old reports, I selected the new data source to generate preview; set data source location; verify database, etc.  I thought these settings were retained with the report - minus the password.  When I open these modified reports to run them, they are pointing to the correct database.  

I'm missing something.
0
 

Author Comment

by:sneeman759
ID: 22604783
When running Crystal Reports 10 (SP6)...
"Failure Audit" is logged at the database when the "OLE DB (ADO)" connection window opens -- before I enter the password.  Server, User ID, and Database values are correctly set; only missing password.  Appears the report is automatically trying to connect to the database with a blank password.  Why?

Same thing happens with new reports.

When Crystal Enterprise 10 (SP6) runs scheduled reports, same thing happens and report fails.  If I manually run the report, it runs and no errors.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22605857
How did you edit the reports to use the new data source?

mlmcc
0
 

Accepted Solution

by:
sneeman759 earned 0 total points
ID: 22608551
Using "set data source".  I've found a means to overcome this problem (derived from documentation on SAP's site):

-  Create DATALINK.UDL and configure to use OLE DB for SQL Server; set database user name and password (checked to store password)
-  Copied DATALINK.UDL to server where Reports are executed
-  Opened report in Crystal Reports; clicked on "set database location";
-  In the bottom window pane, create new connection; OLE DB (ADO); check box "use data link file"; selected DATALINK.UDL
-  In Connection window, database and user name filled in as defined in UDL -- no need to enter password; select database from pull-down
-  Returned to 2-pane window (top: current data locations; bottom: new connections); click on database name in top pane then click database name for desired connection in bottom pane -- click "update" button.
-  Save and run

No more database errors and the report run like a champ.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22608966
Is that how you changed the data source before?

mlmcc
0
 

Author Comment

by:sneeman759
ID: 22615329
Pretty much -- minus the data link file, containing the saved password.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question