Desktop productivity for business analysts and programmers

Error While accessing the Cube

Reply
N/A
Posts: 0

Error While accessing the Cube

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.
Regular Contributor
Posts: 187

Re: Error While accessing the Cube

As it says you are conecting to the Metadata server (port 8561), the Olap server is on another port (could be 5451).
N/A
Posts: 0

Re: Error While accessing the Cube

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

Thanks.
Kiriti
N/A
Posts: 0

Re: Error While accessing the Cube

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
SAS Employee
Posts: 149

Re: Error While accessing the Cube

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/
Ask a Question
Discussion stats
  • 4 replies
  • 202 views
  • 0 likes
  • 3 in conversation