Crystal Report Database Login Error
Contents |
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 crystal report database connector error ControlsLearn BizTalkLearn SharePointLearn MobileLearn SQLLearn SQL ReportingLearn Windows FormsLearn XMLLearn Crystal ReportsLearn crystal report database login prompt FarPointLearn DevExpressExamplesASP.NET 2.0 ExamplesASP TutorialsLearn ASPLearn VBScriptLearn JScriptLearn SQLLearn XMLSoftware ResourcesShopping Cart EcommerceCharts and DashboardsOther ResourcesLearn JavaLearn OracleOpinion /
Vb.net Crystal Report Database Login Prompt
EditorialCrystal 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
Database Login In Crystal Report Viewer
Failed Error in Crystal Reports page 3 of 6 by Richard Dudley Feedback Average Rating:This article has not yet been rated. Views (Total / Last 10 Days): 598361/ 2097 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 crystal report asking for database login 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 designer caches database connection information, so I havefound it best to completely delete all current connections andthen exit and reopen Visual Studio before designing my report. I could then make a fresh connection to the database using the credentials I wanted. You can check by right-clicking the connection in Server Explorer and choosing “properties.” If you're using a SQL Server account, you'll see a user name; if using Integrated Security, the user name will not appear. When using SQL Server authentication, I found it was also best if there
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
Database Login Failed In Crystal Report
more about Stack Overflow the company Business Learn more about hiring developers or posting crystal reports database logon failed sql server ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community database logon failed crystal reports c# Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Crystal Reports Failed Database Login up vote 4 down vote http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.3 favorite After spending a good 3 to 4 hours on google trying to find any solution to my problem I haven't had much luck. Basically, we use crystal reports for our .NET applications with a sql server back end, we have many clients each with their own server and so our reports need to have their connections dynamically set. Up until a week ago this worked fine. However http://stackoverflow.com/questions/2812494/crystal-reports-failed-database-login a few days ago a client reported they were getting a database login prompt for a report (only one report, the rest worked fine). We were quite stumped but we managed to reproduce it on a netbook which didn't have visual studio or sql server installed. In the end the dev decided to reproduce the report in the hope it was just an oddity in that particular report. Unfortunately a new client today also experienced the same problem, but this time for every crystal report they had - and also they worked on the netbook, so we are really quite lost here. Below is a screenshot of what our clients get presented with - and here is the code that I use to set the connection information in the report cI.ServerName = (string)builder["Data Source"]; cI.DatabaseName = (string)builder["Initial Catalog"]; cI.UserID = (string)builder["User ID"]; cI.Password = (string)builder["Password"]; foreach (IConnectionInfo info in cryRpt.DataSourceConnections) { info.SetConnection(cI.ServerName, cI.DatabaseName, cI.UserID, cI.Password); } foreach (ReportDocument sub in cryRpt.Subreports) { foreach (IConnectionInfo info in sub.DataSourceConnections) { info.SetConnection(cI.ServerName, cI.DatabaseName, cI.UserID, cI.Password); } } As always, any help much appreciated. c# .net visual-studio-2008 crystal-reports reporting share|improve this question asked May 11 '10 at 16:28 Marlon 1,01611328 add a comment| 3 Answers 3 activ
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel https://social.msdn.microsoft.com/Forums/en-US/097d8eef-eb46-40ea-987f-783b7f855876/crystal-report-logon-failed-on-adonet-dataset?forum=vscrystalreports 9 Documentation APIs and reference Dev centers Retired content Samples We’re http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10958 sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Crystal Report "Logon Failed" on ADO.NET dataset Archived Forums C-D > crystal report Crystal Reports for Visual Studio (Retired) Question 0 Sign in to vote Hello,I am using.....Net Runtime 1.1CR 9 shipped with vs2003Winforms ApplicationDataSource = ADO.NET datasetI have finished this application a year ago and we have 70+ clients.One of our clients has our program installed on 6 computers. Before few days, the program including crystal report was working fine.Suddenly, crystal report database in last month, CR viewer started popping up error "Logon Failed" with login box with prewritten table name in it.I have checked all logon problems with dataset on every discussion board.All I found was - table name or field name might be wrong.Can anyone think of any program or condition that can cause CR to display “Logon Failed” specially after going well for a year?BTW, All the client machines are windows XP with SP2 on it. Kapil Wednesday, March 29, 2006 5:31 AM All replies 0 Sign in to vote this problem may come if your Server Name / Database Name is different from what u have selected at design time To solve this problem Public Shared Sub Sub_CRCrystalLogon(ByRef rpt As CrystalDecisions.CrystalReports.Engine.ReportDocument)
''CrystalReport1' must be the name the CrystalReport Dim crTableLogOnInfo As TableLogOnInfo = New TableLogOnInfo Dim crConnectionInfo As ConnectionInfo = New ConnectionInfo 'Crystal Report Properties Dim crDatabase As CrystalDecisions.CrystalReports.Engine.Database Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables Dim crTable As CrystalDecisions.CrystalReports.Engine.Table 'Then, use following code sample to add the logic in the Page_Load method of your WeMessage JoerTX Newbie Joined: 25 Aug 2010 Location: United States Online Status: Offline Posts: 10 Topic: Logon FailedPosted: 25 Aug 2010 at 6:00am I am using 2008 with a dotNet app, using a Click Once deployment. At my account there are 5 users who can successfully install Crystal 2008 with click once. However one cannot. The user gets a error when the CAB attempts to register PrintReport.dll. To get around this problem, we downloaded the 2008 SP2 and installed it on that workstation. My app will now install. However, no reports will run. A "Logon Failed" error occurs. I have googled this error code and apparently it is the Crystal version of "check engine light on". Note that this does not occur on any of the other user installations at the site. Only for this user, on this machine. They have totally rebuilt the machine, reformated the drive and reinstalled Windows. For the love of god, does anyone have a clue as to why one user in five cannot successfully logon to the database while running a report?! Pissed off in Houston, JRich IP Logged jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432 Posted: 25 Aug 2010 at 9:31am Dear PO in Houston...:) Generally when this happens it often has to do with the individuals permissions to the backend database. That is the reason for the logon error. Those can be controlled a variety of ways anymore so it is hard to suggest one thing. Still I would suggest you look there if you have had a successful install. If the user has been accessing the data all along then obviously what I just said may not the way to troubleshoot this out. Hope this may be of help Regards, John W. www.CustomReportWriters.net IP Logged JoerTX Newbie Joined: 25 Aug 2010 Location: United States Online Status: Offline Posts: 10 Posted: 26 Aug 2010 at 1:21pm This would be a reasonable conclusion to draw...except for the following 2facts. 1.The reports are run from within an application that already successfully logge