I have Exchange 2000 server and SQL Server 2000 installed on the same box. I using the ExOLEDB data provider to set up Exchange as a linked server in SQL Server. A public folder is queried in a stored procedure using OpenQuery and a SQL Query against the Exchange folder.
This all works fine, as long as the user is an administrator. If a non-admin attempts to use the stored procedure, the SQL Server returns the error "Could not create an instance of OLE DB provider 'exoledb.DataSource.1'.". I know that it can (as I can do it as admin), so it appears to be a permissions problem. What do I need to set to give regular users access to this data? I've tried playing with the permissions in ESM with no luck. Thank you, Erick _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&lang=english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
