You can translate the question and the replies:

Creating a Multidimentional Datasource | SQL Server analysis Services

Hello, We have created a Multidimentional Datasource of SQL Server analysis Services. I have followed the Denodo article - https://community.denodo.com/kb/view/document/SSAS%20as%20data%20source?category=Data+Sources (have also followed all the Previous considerations listed) While trying to "Create Base view" I am getting the error as "Unable to connect to the multidimensional server: org.olap4j.OlapException: This connection encountered an exception while executing a query." I have checked on the issue and it seems to come when there is an access issue but I have checked the access of the account used to connect and the account has access in denodo and SQL server both. Can you please help on what we might be missing here? Thanks, Gokul

5 Answers

Hi, This error could occur if the user who starts the Denodo Server doesn’t have access to the SSAS Server through the HTTP interface. I would suggest you to launch the Denodo Platform with an administrator user account and check if that user has enough privileges to access the SSAS server. Hope this helps!
Denodo Team
27-04-2020 07:27:31 -0400
I logged in to Denodo with a user with the access to SSAS yet still facing the same error!
user
27-04-2020 09:28:43 -0400
Hi, Check if your IIS Configuration for SSAS is set to Basic Authentication and not to Windows Authentication. This could prevent Denodo from connecting to SSAS. If the issue persists and you are a user with a valid Support account, you may open a support case at the [Denodo Support Site](https://support.denodo.com/MainPage.do). Hope this helps!
Denodo Team
13-05-2020 02:15:46 -0400
Hi, Check if your IIS Configuration for SSAS is set to Basic Authentication and not to Windows Authentication. This could prevent Denodo from connecting to SSAS. If the issue persists and you are a user with a valid Support account, you may open a support case at the [Denodo Support Site](https://support.denodo.com/MainPage.do). Hope this helps!
Denodo Team
13-05-2020 02:16:07 -0400
Hi, Check if your IIS Configuration for SSAS is set to Basic Authentication and not to Windows Authentication. This could prevent Denodo from connecting to SSAS. If the issue persists and you are a user with a valid Support account, you may open a support case at the [Denodo Support Site](https://support.denodo.com/MainPage.do). Hope this helps!
Denodo Team
13-05-2020 02:16:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here