SQL Server 2000 Reporting Services Error

Problem: "Provider cannot be found. It may not be properly installed."

Solution: This error occurs because a dynamic-link library (DLL) that is required by the Microsoft Data Access Components is not registered. This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as
an example. Because the unregistered DLL may vary based on the OLE DB Provider that you are using, modify step 2 accordingly.

Reregister the faulty DLL as follows:
1. At the command prompt, change to the C:\Program Files\Common Files\System\Ole DB folder.
2. Type regsvr32 sqloledb.dll
3. Some popup message should display saying that the DLL was registered successfully.
See: http://support.microsoft.com/default.aspx?scid=kb;en-us;278604

---