topic Error trying to connect to OLAP server in SAS EG in Administration and Deployment

Error trying to connect to OLAP server in SAS EG

thesasuser — Wed, 31 Jul 2019 18:23:34 GMT

SOme of the SAS users have issues connecting to OLAP server while others can.(There are no OLAP cubes.).
The server is 9.4M6 and client in EG7.13.
The error message is as follows.

--------------------

Exception details:-

You do not have the appropriate permissions to connect to this server.

-------------------------- Technical Information Follows --------------------------

Exception Details:

----------------------------------------

Exception type: SAS.OCT.CubeData.AuthorizationFailedException

Message: You do not have the appropriate permissions to connect to this server.

Source: SAS.OCT.OlapClientEngine

Target Site: CreateConnection

......

--------------------------

Can anybody suggest a solution

Re: Error trying to connect to OLAP server in SAS EG

AnandVyas — Thu, 01 Aug 2019 05:24:51 GMT

Hi @thesasuser,

Are there any ACTs applied in your environment?
Are the users part of separate groups in SMC? If yes, can you validate the permissions for both the groups?
Try to explicitly grant permission to an user who is getting this error to see if it works.

This Kb has some steps to overcome permission related issues.
http://support.sas.com/kb/14/626.html

Thanks!

Re: Error trying to connect to OLAP server in SAS EG

thesasuser — Thu, 01 Aug 2019 15:20:57 GMT

Thanks Anand.
As we are not using OLAP cubes, removed readmetadata permissions.
So issue got resolved