Craxdrt Error Occurred On Server Logon Failed
-2147189176 : Logon failed. If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Crystal Reports CRAXDRT error on Server. -2147189176 : Logon failed. Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-03-10,22:53 #1 shell_l_d View Profile View Forum Posts Registered User Join Date Dec 2009 Posts 23 Unanswered: Crystal Reports CRAXDRT error on Server. -2147189176 : Logon failed. 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 Last edited by shell_l_d; 08-04-10 at 01:27. Reason: Added list of software on server... Reply With Quote 08-16-10,01:38 #2 shell_l_d View Profile View Forum Posts Registered User Join Date Dec 2009 Posts 23 This seems to fix it: Open each problematic Crystal Report *.rpt file File > Summary Info > Template: leave blank (was 'LOCALDSN' without the quotes) Reply With Quote Quick Navigation Crystal Reports Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal
AspAllianceRegisterEdit My ProfileAuthor ListWrite for UsAbout AspAllianceContact UsPrivacy PolicyLink To UsAdvertiseSubscribeFree NewsletterNewsletter ArchiveRSS Syndication .NET TutorialsLearn .NETLearn WCFLearn WPFLearn ASP.NETLearn AJAXLearn SilverlightLearn Visual StudioLearn ADO.NETLearn LINQLearn C# (CSharp)Learn VB.NETLearn Web ServicesLearn ControlsLearn BizTalkLearn SharePointLearn MobileLearn SQLLearn SQL ReportingLearn Windows FormsLearn XMLLearn Crystal ReportsLearn FarPointLearn DevExpressExamplesASP.NET 2.0 ExamplesASP TutorialsLearn ASPLearn VBScriptLearn JScriptLearn SQLLearn XMLSoftware ResourcesShopping Cart EcommerceCharts and DashboardsOther ResourcesLearn JavaLearn OracleOpinion / EditorialCrystal http://www.dbforums.com/showthread.php?1659021-Crystal-Reports-CRAXDRT-error-on-Server-2147189176-Logon-failed Reports AllianceWPF ResourcesAJAX ResourcesSilverlight ResourcesFree ToolsCache ManagerSimpleCMSReviewsBook ReviewsProduct ReviewsExpert AdviceBooksASP.NET Developer's CookbookSample ChaptersBook ReviewsCommunityRegular Expressions Print Add To Favorites Email To Friend Rate This Article Understanding the Login Failed Error in Crystal Reports page 3 of 6 by Richard Dudley Feedback Average Rating:This article has not http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.3 yet been rated. Views (Total / Last 10 Days): 598346/ 2086 Article Contents: Introduction Lesson 1: Integrated or SQL Server Security Lesson 2: Only One Security Model Allowed Lesson 3: Credential Delegation/Impersonation ("Double Hop") Lesson 4: Design Changes Sometime Cause Login Failure Conclusion Lesson 2: Only One Security Model AllowedThe Crystal Reports engine cannot switch from Integrated Security to SQL Server security. This means that if you design your report using Integrated Security, you must supply a domain user's credentials in code to log on to the SQL Server (you can change the user, but it must be a domain account). If you will be using a SQL Server account in production, it is very important that you use this account's credentials to connect to the database during the design phase. The CR designe
help? Post your question and get tips & solutions from a community of 418,471 IT Pros & Developers. https://bytes.com/topic/asp-classic/answers/59476-crystal-report-login-problems-asp It's quick & easy. Crystal Report Login Problems in ASP P: n/a jeremylim2000 Hi! I try to preview a crystal report using asp, it prompt 'CRAXDRT error Occured on server. https://social.technet.microsoft.com/Forums/en-US/21234dbe-eb80-4d90-8252-5f5ee3408727/crystal-report-viewer-error-craxdrt-error-occured-on-server-507-an-exception-occured?forum=winservermanager -2147189176 : login failed Details : IM002 :[Microsoft][ODBC Driver Manager] Data sourcename not found and n default driver speci fied'. I use below syntax, For Each mnTable in mainReportTableCollection With craxdrt error mnTable.ConnectionProperties .Item("user ID") = "sa" .Item("Password") = "m-m-t-12:26pm-m" .Item("DSN") = "odbc_winwin" .Item("Server") ="MMXP" .Item("Database") ="dbmlm_winwin" End With Nex - jeremylim200 ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Jul 19 '05 #1 Post Reply Share this Question 2 Replies P: n/a Turkbear On Wed, 6 Oct 2004 02:15:29 -0500, jeremylim2000
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Crystal Report Viewer Error: "CRAXDRT Error Occured on Server. 507 : An Exception Occured" Windows Server > Server Manager Question 0 Sign in to vote We have recently setup Window Server 2003 SP2 (IIS V6.0) with Crystal Report 8.5 installed. All things working well for report viewer in internet browser, but only the problem is when user trying to export report to a file (CR/word/rich text/etc format) will hit the error:CRAXDRT Error Occurred on Server. 507 : An exception occurredOnly option is click "OK" to continue... Well, so we just click "OK" and try again... Note that, for second tried onward will hit another error:CRAXDRT Error Occurred on Server. 70 : Permission deniedIt was annoying us as export crystal report to a file is the major part for our daily operation. We have search over the intranet and there are so many similar cases but without a clear direction where this error was hitted.In addition, I have done some permission setting between my website in IIS and CR Viewer, i.e. shared viewer to the website, set permission of viewer to allow access of anonymous intranet user... unfortunately still can't work...Look forward to experienced to share the solution/opinion. Thanks! Friday, October 17, 2008 3:10 AM Reply | Quote Answers 0 Sign in to vote Hi customer, According to the description, the issue seems to be related to the third party application Crystal Reports. I am afraid that I have to say that we are not the best resource. You may refer to the following KB article find the technical support of Crystal Reports you need. The engineers and community members there are more specialized on the Crystal