topic Connect to SQL Services Analysis Services with QS April 2018 patch 1 in Connectivity & Data Prep

Connect to SQL Services Analysis Services with QS April 2018 patch 1

wdchristensen — Tue, 28 Dec 2021 20:53:06 GMT

We have some SQL Services Analysis Services data cubes that I would like to connect to. I am trying to replace the functionality that currently resides in Excel with Qlik Sense. I want to create a connection to SSAS cube but I am currently unable to connect. I can create an OLE DB connection using a trusted connect (AD account) to the SQL server database engine on the standard port 1433. My AD account is a member of the SA group for SQL Server and I can connect to the cubes using SSMS. If I change the port to use the standard port 2383 for SSAS I get an error. Please help me set up the connection! I am using Qlik Sense April 2018 Patch 1.

Re: Connect to SQL Services Analysis Services with QS April 2018 patch 1

robert_ramos — Fri, 02 Aug 2019 13:23:57 GMT

This is not possible with your version of Qlik so you can upgrade or use Power BI.

Re: Connect to SQL Services Analysis Services with QS April 2018 patch 1

wdchristensen — Thu, 15 Aug 2019 14:21:35 GMT

Case # 01693456 - CAN'T CONNECT TO SSAS ON PORT 2383

https://technet.microsoft.com/en-us/windows/mt592624(v=sql.90)

Re: Connect to SQL Services Analysis Services with QS April 2018 patch 1

jonathanhvid — Wed, 19 Feb 2020 09:56:51 GMT

Hi,

Hope you solved this. If you are looking for an easier way to connect to SSAS and AAS, have a look at the connector made for the purpose:

https://www.youtube.com/watch?v=DRTUqxUk7-E&lc=z22udxxjmqrixlwslacdp4302be0y0sn3reg4mwhlhtw03c010c

https://market.qlik.com/solutions/Cube_Connector_for_Multidimensional_&_Tabular_SSAS_Models

Makes it a lot nicer to work with 🙂

/ Jonathan