Error While accessing the Cube

[deleted_user]

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.

[FredrikE]

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

[deleted_user]

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

Thanks.
Kiriti

[deleted_user]

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

[RichardH_sas]

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/