Can't connect to Azure Analysis Services in SQL Server Profiler

Question

Can't connect to Azure Analysis Services in SQL Server Profiler

Gabriel Flores 41

I can connect to the AAS instance using SSMS Object Explorer and Excel but if I try to do so using SQL Server Profiler, i receiver this error

An unexpected error occurred (file 'pfadalauthinfo.cpp', line 1031, function PFAdalAuthInfoConfigurationWrapper::GetInstance') pfutil

Note, we are using MFA using Okta to login.

I installed the latest SSAS drivers from here
https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions

Below is my SSMS version (latest - v18.10)
SQL Server Management Studio 15.0.18390.0
SQL Server Management Objects (SMO) 16.100.46521.71
Microsoft Analysis Services Client Tools 15.0.19714.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.18363

Strangely, on a different machine with SSMS, I can connect just fine. That one is on version SSMS v18.9.2 (15.0.18386.0). Could be related to other issues

CarrinWu-MSFT 6,891 Reputation points

2022-01-06T02:55:24.187+00:00

Hi @Gabriel Flores , thanks for your post. I just work with on premise SSAS, so I don't have permission to make a test with Azure Analysis Service. Which SSAS engine version did you install? Based on my research, I found a similar thread and this error fixed by SSAS 2019 CU12. And Azure also provides a simple SQL Server tracing solution similar to SQL Server Management Studio (SSMS) Profiler. For more information, please refer to SQL Server Profiler extension (Preview).
Gabriel Flores 41 Reputation points

2022-01-06T03:18:28.11+00:00

hi @CarrinWu-MSFT , thank you for your response. However, this issue is specific to Azure Analysis Services and multi-factor authentication (SQL Server 2019 is not relevant here).

Also, Azure Data Studio doesn't support Analysis Services (thus, SQL Server Profiler extension (Preview) is not supported either for SSAS).
https://github.com/microsoft/azuredatastudio/issues/1026

I mainly created this question in case there were others who experienced the same issue. Google results were lacking for this specific error.
Gabriel Flores 41 Reputation points

2022-02-16T22:27:01.957+00:00

This is definitely a driver issue.. we're seeing other users experience the same thing in Excel, Visual Studio, Tableau. (on certain version/configurations).

Accepted answer

0 additional answers

Your answer

CarrinWu-MSFT 6,891 Reputation points

2022-01-06T02:55:24.187+00:00

Hi @Gabriel Flores , thanks for your post. I just work with on premise SSAS, so I don't have permission to make a test with Azure Analysis Service. Which SSAS engine version did you install? Based on my research, I found a similar thread and this error fixed by SSAS 2019 CU12. And Azure also provides a simple SQL Server tracing solution similar to SQL Server Management Studio (SSMS) Profiler. For more information, please refer to SQL Server Profiler extension (Preview).
Gabriel Flores 41 Reputation points

2022-01-06T03:18:28.11+00:00

hi @CarrinWu-MSFT , thank you for your response. However, this issue is specific to Azure Analysis Services and multi-factor authentication (SQL Server 2019 is not relevant here).

Also, Azure Data Studio doesn't support Analysis Services (thus, SQL Server Profiler extension (Preview) is not supported either for SSAS).
https://github.com/microsoft/azuredatastudio/issues/1026

I mainly created this question in case there were others who experienced the same issue. Google results were lacking for this specific error.
Gabriel Flores 41 Reputation points

2022-02-16T22:27:01.957+00:00

This is definitely a driver issue.. we're seeing other users experience the same thing in Excel, Visual Studio, Tableau. (on certain version/configurations).

Answer 1

Marc Z 81

We were using Excel 2016 MSO and had the same issue. We worked with Microsoft support directly and they found an issue with the client libraries, namely the MSOLAP. New versions were posted to the site:

https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions

Once we uninstalled all previous versions and installed these (And rebooted), all is well now and we can connect to Azure Analysis services

Gabriel Flores 41 Reputation points

2022-03-03T21:40:54.857+00:00

Thanks for working with Microsoft support directly! This will be a huge relief to our customers.

They placed a note on their documentation regarding this:

MSOLAP
A regression related to connections to cloud-based systems using AAD was discovered in the 16.0.4.17 version of OLEDB (MSOLAP). It was fixed in the 16.0.20.201 version. Due to the nature of
the issue, an installed 16.0.4.17 version, as well any other version prior to 16.0.20.201, cannot be corrected by simply upgrading the provider, even if setup is run in repair mode. It’s recommended to completely uninstall the 16.0.4.17 [or other problematic] version and then install the 16.0.20.201 or later version.

Share via

Can't connect to Azure Analysis Services in SQL Server Profiler

0 additional answers

Your answer