BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
thesasuser
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anand_V
Ammonite | Level 13
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!

View solution in original post

2 REPLIES 2
Anand_V
Ammonite | Level 13
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!
thesasuser
Pyrite | Level 9

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 539 views
  • 0 likes
  • 2 in conversation