Can anyone tell me whether it is possible to successfully connect to an Exchange 2003 email server from a SQL Server 2005 server and interrogate the folders with TSQL please? BOL has a very brief and not too clear section that an Exchange server can be added as a linked server but doesnt give enough detail for me to make a successfull connection between our servers.
Exchange and SQL are on different hardware which I understand is not a show stopper so, for sake of this example we have: SQLSvr and ExchSvr on the MyDom.net domain.
I have executed several variations of:
EXEC sp_addlinkedserver 'TestExchange', 'Exchange OLE DB provider', 'c:\program files\exoledb', 'file:\\.\backofficestorage\MailSrv.MyDom.net\public folders'
and after running a query or try to use Object Explorer to view the object get the same error of
Msg 7403, Level 16, State 1, Procedure Contacts, Line 4 The OLE DB provider "c:\program files\exoledb.DataSource.1" has not been registered.
I have copied the exoledb.dll from ExchSvr and registering it on SQLSvr but the error still occurs.
Can anyone advise me what other steps need to be taken please?