We need to access an Exchange Server public folder store to get a list of public folders, and their contents, to put up on a report.
Small Business Server 2003 R2 Premium Edition - all service packs and updates installed.
NOTE: We did NOT install SQL 2005 Workgroup - we purchased and installed SQL 2005 Standard to get the BI tools.
Unfortunatley, I can't seem to get the cooperation of the Exchange OLE DB provider.
The settings I'm using for the connection manager are as follows:
Server or file name: http://myserver/exchange
Use a specific user name and password: username = Administrator Password = ********
Allow saving password = TRUE
When I test the connection, I get the following error:
Test Connection failed because of an error in initializing provider. No error message available, result code: DB_E_NOTFOUND(0x80040E19).
Thank you all,