473,380 Members | 1,382 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,380 software developers and data experts.

Logon Error using Crystal Reports in VS.net Web App

Hi,
I have been trying to load a Crystal Report newly created via VS.Net 2003.
I am using a simply ASP form with only the Crystal Report Viewer. The
sample report results display in the WebForm1.aspx, when I have set the
databinding Report Source property set at design time.

I get the following error message when I try to run the report.
CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.

In searching Google, in several instances it advised to set the properties
via code instead of at design. This is the suggested code that I placed in
the PageLoad. I am using a dataset created via a SQLAdapter dragged from
the Toolbox. Within Crystal, I tried using the Project dataset and the
Connection Dataset. I even tried a new ODBC connection to the server.
Dim oRpt As CrystalReport3

oRpt = New CrystalReport3

'oRpt.SetDatabaseLogon("user", "password")

'oRpt.SetDatabaseLogon("user", "password","server","database")

CrystalReportViewer1.ReportSource = oRpt

Me.SqlDataAdapter1.Fill(Me.DataSet11)

CrystalReportViewer1.DataBind()

Since most of the discussion on Google centered around the logon info, I
have tried with and without setting login and using different syntax. I
still end up with the same error message.

Once again the Google discussion says that Crystal does not use Windows
Authentication that allows permission to ASPNET users. I am not overjoyed
about have my password in the code, but right now I would be happy getting
any Crystal report executing.

Are there any suggestions or corrections. One comment said that the user
and password were the SQL user and password found in the Config file. But
since my app is set up to use ASPNET as permissible users, there is nothing
in the Config file.

By the way, how do I verify what my SQL UserID and Password are? I have
just set up this environment recently, it is possible that I am using the
wrong combination.

thanks,
hugh

Nov 21 '05 #1
3 1667
Hi Hugh,

Since Crystal report as a third party product issue is supported by
Business Objects.

I suggest you post in the crystal report forum for further response.
Here is the Forum you may have a try.
http://support.businessobjects.com/f...?fid=251&sk=5&
http://support.businessobjects.com/

Crystal Reports Samples
http://support.businessobjects.com/fix/samplescr.asp

Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 21 '05 #2
Peter,
Thanks a great deal. I had a feeling that it did not quite belong with VB
but I did not know where. It did not seem to be an SQL Server question.

It helps to learn the different and correct avenues. These newsgroups are a
great help. I am making real progress with this app of mine.

thanks again,
hugh
""Peter Huang" [MSFT]" <v-******@online.microsoft.com> wrote in message
news:ma**************@TK2MSFTNGXA01.phx.gbl...
Hi Hugh,

Since Crystal report as a third party product issue is supported by
Business Objects.

I suggest you post in the crystal report forum for further response.
Here is the Forum you may have a try.
http://support.businessobjects.com/f...?fid=251&sk=5&
http://support.businessobjects.com/

Crystal Reports Samples
http://support.businessobjects.com/fix/samplescr.asp

Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.

Nov 21 '05 #3
Hi

You are welcomed!
If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ambika Srinivasan | last post by:
Hi, I am getting the following error running a crystal report with VB.NET Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. Source Error:
0
by: Max | last post by:
Hi wise people, Has anyone encountered the Crystal Reports problem I describe below? If so, how did you solve it? It seems that every article posted on google regarding CR and logon problems is...
0
by: Mukesh Kumar | last post by:
hi all, I have created some independent reports through crystal reports developer edition v 10 and developed a small tool in .net framework v 1.1 to view these reports through the crystal reports...
2
by: Mark Miller | last post by:
I'm not sure why this is happening. I'm trying to run a late-bound report. My original code looked like this: TableLogOnInfo logOnInfo = new TableLogOnInfo ();...
0
by: google | last post by:
My Crystal reports are being supplied the logon credentials via a C# code class that recursively loops through all the tables present in the reports and applies the login credentials (Servername,...
2
by: Karun Karunakaran | last post by:
Hi, I am using the Crystal Enterprise .NET assemblies to generate and display a crystal report in a webform. This report connects to an SQL server (running locally) using a specific username and...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most basic report purely for testing purposes: connect to...
9
by: mollyf | last post by:
I have tried various suggestions that I have found searching the newsgroups and still haven't been able to figure why I keep getting the logon failed error. I created a report in Crystal (not...
19
by: Michael O'Donnell | last post by:
Hi All Am having major problem with crystal reports...Have designed my report no problem, its when I try to run and display ther report that I am getting a "Login Failed" message. At first I...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.