Crystal Reports CRAXDRT error on Server. -21471891 Logon failed

[shellld]

Crystal Report CRAXDRT error - logon failed

ERROR MESSAGE BOX:
Crystal Report Viewer
CRAXDRT Error Occured on Server. -2147189176 : Logon failed.
Details: [Database Vendor Code: 18456]

* Crystal Reports being run via ASP code & IIS.
* Very intermittent error, cant find pattern - appears sometimes & not others.
* With some testing, found after a while or after running several diff crystal reports it seems to come good again OR when restart IIS (eg: Start -> Services -> 'IIS Admin Service' - restart).
* hourly auto updates are being done by IT on the server, not sure what changes/updates took place just before the problem started,
but customer does recall Crystal Reports was upgraded, think from version 9 to 11, so can dump into Excel. However this may have been some time ago.

Any ideas please?

* tried remapping datasource in all reports
* noticed many temp tables in code, some were changed to table variables

Relevant Software on Server:
* CR 8.5 (not in Start Menu though)
* CR 9 Developer
* CR 11 Developer
* Win Server 2003 SP2

 

[Turkbear]

Hi,
That error from SqlServer can have several variants:

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

or

http://sqldbpool.com/2009/04/24/error-18456-severity-14-login-failed-states/

have the details about the severity codes associated with this error - they may help you isolate which one is affecting the login.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[shellld]

Sorry turkbear, didnt see your response until now. The popup error doesn't show me a severity code, only the information I posted in my original post.

Also nothing shows in the Windows Event Viewer (Application, Security & System) logs.

How do I find this information out please?

 

[shellld]

This seems to fix it:
Open each problematic Crystal Report *.rpt file
File > Summary Info > Template: leave blank (was 'LOCALDSN' without the quotes)