MFA Authentication Issues

Bundhoa, Ricky 1 Reputation point
2022-08-12T12:56:49.833+00:00

Hi I am getting below error while trying to use MFA authentication to connect to my Azure Analysis Services server from SSMS.

I have tried upgrading the dlls but the error is persistant.

===================================

Cannot connect to asazure://northeurope.asazure.windows.net/Servername.

===================================

Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient)

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

Program Location:

at Microsoft.AnalysisServices.AdomdClient.Authentication.AdalAuthenticationHandle.AdalAuthenticationService.AuthenticateUser(AuthenticationOptions options, AuthenticationInformation authInfo)
at Microsoft.AnalysisServices.AdomdClient.Authentication.AuthenticationManager.Authenticate(AuthenticationOptions options, String identityProvider, String resource, String tenantId, String userId, String password, Boolean isForAsAzureRedirection)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.AcquireToken(IConnectivityOwner owner, String resource, String tenantId, Boolean isForAsAzureRedirection)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.ResolveHTTPConnectionPropertiesForPaaSInfrastructure(IConnectivityOwner owner, Uri& dataSourceUri, Boolean acquireAADToken, Boolean returnCloudConnectionAuthenticationProperties, String& paasCoreServerName, CloudConnectionAuthenticationProperties& cloudConnectionAuthenticationProperties)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenHttpConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnectionAndCheckIfSessionTokenNeeded(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.<>c__DisplayClass95_0.<OpenConnection>b__0()
at Microsoft.AnalysisServices.AdomdClient.Platform.Security.TransparentUserContext.ExecuteInUserContextImplTResult
at Microsoft.AnalysisServices.AdomdClient.Platform.Security.UserContext.ExecuteInUserContextTResult
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

The path is not of a legal form. (mscorlib)

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

Program Location:

at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.RunAsyncTaskT
at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.AcquireToken(String resource, String clientId, Uri redirectUri, PromptBehavior promptBehavior)

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
445 questions
{count} votes