Crystal Report Generating error for push model while printing or exporting

Ezhar Anasri

HI
I have created a Crystal report using push model. While viewing the data I am getting the correct output as I have already used
SetDatabaseLogon() method.
But While I am trying to print or export I am getting this 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: Error in File C:\DOCUME~1\3edge\LOCALS~1\Temp\Form-3A {ED78A428-2AA9-40FD-9D61-16D33D548D83}.rpt: Unable to connect: incorrect log on parameters.

While I check then I found that I am using OLE DB connectivity to SQL Server (SQL Authentication) and my SQL db is in a server. And the Database expert in not saving my password when ever I am creating a Connection

Please help me how to come out this problem.
Thnx in Advance.

3 Replies

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

Vilas Gite15y ago
hI Ezhar,

Please refer this.
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-dynamic-login.htm

hopes it will solve your problm.
0
Ezhar Anasri15y ago
If the issue is with permission then I would not be able to display the data but I am able to display the problem is with database expert of crystal report. I do not know how to save the password.
0
Vilas Gite15y ago
Hi Ezhar, I am not confirmed, but Please to check Properties of SQL Server and ensure Explicit permission for Public logins or roles is granted for sa in grantor Permission.
0