Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed

Introduction:

In this article I will explain how to solve problem of “Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed” during deploy crystal reports in server.

Description:

After create crystal reports if I run in my system it’s working fine whenever I deployed crystal reports to server I got error like Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed.

I didn’t get why I am getting this error because it’s working very well in my local system after sometime I realized that I am getting this error because of missing SQL Native Client in server. During the time of creating the crystal report I selected SQL Native Client or SQLNCLI as OLEDB provider it works perfectly in my system because of SQL Native Client or SQLNCLI already install in my machine. To solve this problem in your server you need to change OLEDB provider of your report from SQL Native Client to Microsoft OLE DB Provider for SQL Server and deploy to your server it will work for you.

Another way we can solve this problem by installing SQL Native Client drivers (sqlncli.msi) in your server. You can download it from here 

Sqlncli.msi

After install sqlncli.msi component in server run your application it will work for you.