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.