MS SQL Server - link server to 2000 AS cube?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

link server to 2000 AS cube?

angi

2006-04-07, 3:24 am

Hi,

I set a Link Server as "OLAP8" on SQL 2005 and link to AS 2000 Cube.
(use ADOMD.NET 8.0)
It is work well on local server.
But when I execute query from another server ( SQL 2005 and account is the
same as local server ), it responsed :

OLE DB provider "MSOLAP" for linked server "OLAP8" returned message "The
following system error occurred: Access denied¡C .".
Msg 7373, Level 16, State 2, Line 1
Cannot set the initialization properties for OLE DB provider "MSOLAP" for
linked server "OLAP8".

What's happen? Thanks for help!

Angi

Sponsored Links