Skip to Content
0
Former Member
Jan 20, 2012 at 02:56 PM

Problem with SQL Native Client provider

60 Views

Hi,

We are using asp for launching the Crystal reports using RDC methodology. Reports are created using Crystal Reports XI, SQL native client provider is used. (Web server and RM (data) servers are different) Reports are launching fine in one web server. The same report deliverables when deployed in other web server (Web and RM servers are different) it is not working. It is throwing the error ado error Logon_failed (Database_Vendor_Code:_18456). Error occurred during verify data base also.

How to overcome this issue? In the same environment the reports that are developed using sqloledb provider is getting launched without any issue.

Is it SQL Native Client provider should be installed in the web server? I tried using multiple web servers with and without SQL Native Client provider in both the cases the reports are not launching.

Crystal reports version : Crystal Reports XI

Windows OS : Windows2003

SQL Server 2005

Thanks in advance.