I have stored procedure running an OpenRowset query against Analysis
Services. When I ran it from SQL Server 2000, it runs fine. When I ran it
from SQL Server 2005 I get the message:

OLE DB provider "MSOLAP" for linked server "(null)" returned message "The
following system error occurred: No connection could be made because the
target machine actively refused it. .".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSOLAP" for
linked server "(null)".

Since I'm using OpenRowset, why is it looking for a linked server? Does
anyone knows how to fix this?

Thanks in advance for any help,

Carmen

you tried using msolap.3 i believe as the data source

you got the correct drivers on the relational machine?




"Carmen" <Carmen (AT) discussions (DOT) microsoft.com> wrote