topic Re: Error While accessing the Cube in SAS Enterprise Guide

Error While accessing the Cube

deleted_user — Thu, 09 Jul 2009 15:11:59 GMT

Hi,

Any idea on following error, i got this error while executing the below given statement in EG .

proc sql;

connect to olap (host= "SERVER" port=8561 protocol=bridge userid="ABCD"

pw="{sas001}SGdoZ2hnMTIz"

repository="Foundation"

olap_schema="SASMain - OLAP Schema");

quit;

I have supplied the server name and userid/password correctly.

Error Message:

The client has connected to a SAS Metadata Server (v1.0) when it intended to connect to a SAS OLAP Server.

Re: Error While accessing the Cube

FredrikE — Thu, 09 Jul 2009 15:27:39 GMT

As it says you are conecting to the Metadata server (port 8561), the Olap server is on another port (could be 5451).

Re: Error While accessing the Cube

deleted_user — Thu, 09 Jul 2009 15:52:24 GMT

Hi FredrikE,
i have identified the correct port number for OLAP server adn changed it , is working now .

Thanks.
Kiriti

Re: Error While accessing the Cube

deleted_user — Thu, 09 Jul 2009 16:08:41 GMT

Hi,
Any idea on following error, i got this error while executing statement in EG .
I have supplied the server name and userid/password correctly.

Error Message:

ERROR: An anonymous user cannot perform this function (calling interface MDXServer_1_0). Please supply a userid and password when

connecting to the server.

Thanks in advance
Kiriti

Re: Error While accessing the Cube

RichardH_sas — Mon, 13 Jul 2009 11:55:34 GMT

Regarding the second question, it might be an issue of whether the query is being executed on a stored process server or a workspace server. Everything on the stored process server runs under a shared ID, whereas stuff on a workspace server uses the individuals credentials. This is just a guess though. You might want to check with SAS Tech Support since they would know the correct questions to ask: http://support.sas.com/techsup/contact/