Solved

SQL 2005 Failure Audit When Running Crystal 10 Reports

Posted on 2008-09-29
12
378 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
 

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now