crystal report export into pdf

Suresh Babu

am trying to export the crystal report into pdf but am getting the follwing error
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'sa'.
SQL State: 42000
Native Error:

and this is my code

ReportDocument pdfReport = new ReportDocument();

BptApplicationPrintrpt bpt = new BptApplicationPrintrpt();

bpt.Load(Server.MapPath("~/Reports/BptApplicationPrintrpt.rpt"));

// pdfReport.SetDatabaseLogon("amitjain", "password", @"AMITJAIN\SQL", "Northwind");

Response.Buffer = false;

Response.ClearContent();

Response.ClearHeaders();

bpt.SetParameterValue("Appno", clsMFields.ApplicationNo);

-->am getting error at this line bpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Employees");

Response.End();
please help me.. please solve my problem

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Hi,
Please refer the below link

http://aspalliance.com/490_Troubleshooting_Database_Login_Errors_using_Crystal_Reports_with_NET.all

Regards,
Iftikar
Suresh Babu13y ago
already my sa is enabled..
please see my error carefully

Exception Details: System.Runtime.InteropServices.COMException: Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'sa'.
SQL State: 42000
Native Error: Error in File C:\Users\SUDHAKAR\AppData\Local\Temp\BptApplicationPrintrpt {6B3A4939-367A-459F-AFF9-BE29FF50AAE9}.rpt:
Unable to connect: incorrect log on parameters.
please help me
NAGARAJU TAMADA13y ago
Login failed for user 'sa'. Reason: The account is disabled. SQL Server
As the error says the particular login is Disabled. Thus, we need to enable the user.

Follow these steps to enable the user.

Go to start -> programs.
Open Sql server management studio
Login to the SQL server (using windows authentication).
Expand the security tab.
Expand the Login folder.
Select the user for which you got this error. In this case 'sa'.
Right click and select properties.
Enable the user.
Save settings.

Now it should work fine. Hope this will help.

Regards
NagRaju

It its work fine,Please Mark as answer."It Will Help Someone else"
Renish Patel13y ago
Hi Suresh,

Here you see step by step information for making crystal report,Please check this out..You get your solution here
http://www.beansoftware.com/ASP.NET-Tutorials/Export-Crystal-Reports-To-PDF.aspx

If your query solve then mark this post as answer.

Thanks

Renish Ankola

crystal report export into pdf

Login failed for user 'sa'. Reason: The account is disabled. SQL Server