Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL 2005 Failure Audit When Running Crystal 10 Reports

Posted on 2008-09-29
12
395 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 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