CODEWITHSUNDEEP
sql-servercrystal-reportsoledb
DareDevil
DareDevil

Reputation: 5349

Logon failed, ADO Error Code: 0x

Up until a few weeks ago, my report successfully connected to the SQL Server. Now it shows this error:

---------------------------
Crystal Reports ActiveX Designer
---------------------------
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
SQL State: 08001
Native Error: 
---------------------------
OK   
---------------------------

How can I resolve this?

Upvotes: 1

Views: 9405

Answers (2)

Nitin
Nitin

Reputation: 1

This issue is not related to crystal report.This is related to oledb provider, if your current provider is "Microsoft OLE DB provider for SQL Server" change it to "Microsoft OLE DB Driver for SQL Server" or SQL server Native Client 11.0 and +. Please create .UDL file and test.

Upvotes: 0

Ajay2707
Ajay2707

Reputation: 5808

To resolve this error, simply update your crystal report with new sqlserver db. This error shows that your credential of sqlserver and report datasource's credentials are mismatch.

Ideally if you do this via your code, then always write this statement which dynamically access and set credentails 

ReportDocument cryReportDocument = .......;
cryReportDocument.SetDatabaseLogon("userName", "password");
cryReportDocument.SetParameterValue("parameterName", value);
CrystalReportViewer1.ReportSource = cryReportDocument;

See the links

How to prevent Crystal Reports from requesting credentials/parameters when setting the datasource directly?

Dynamically set Crystal Report still asks for db login

https://www.codeproject.com/Questions/696567/crystal-report-Runtime-Login-Prompt

This clearly tell you that something wrong with credentials. If this is in designer, it means your server definition may be change, so while connecting in update it required the exact db credential. Just recheck via Database->Verify Database and I think this resolved your issue.

Why do I get "Database logon failed" in Crystal Reports when using .NET object as datasource?

Upvotes: 0

Related Questions