Friday, February 24, 2012

Connecting Other Analysis Services present in N/w

I'am new to SQL Server Analysis Services. Currently i have downloaded "SQL Server 2000 Analysis Services" and also have SP4 on it. The help says its Version 8.00.2039.

The same environment has been setup in another machine also and now i'am trying to register the other machine in my Analysis Manager. While trying them it shows the following error

"Errors occurred while connecting to Mch-Name. ActiveX component can't create object. Do you still want to register this server "

Basically i want to connect to other machine and access the Cubes created in that machine.

Any help on this will be appreciated.

Thanx in Advance

Kishore BG

AS 2000 requires for you to open a share on the remote machine. Try and search for "MsOLAPRepository$", you should find quite a bit information about how to setup remote administration in AS2000.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment