Unable to connect to Azure Virtual Machine(VM) with SQL Server Analysis Services(SSAS) installed using SQL Server Management Studio(SSMS)

Question

I'm trying to deploy an MSOLAP multidimensional cube, using Visual Studio, to Azure VM with SSAS installed. However, the deployment failed due to the following error

Severity Code Description Project File Line Suppression State
Error The project could not be deployed to the '<ipv4 address of Azure VM>' server because of the following connectivity problems :
Authentication failed.
To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

I was CONFUSED about impersonation credentials so I decided to check whether I can connect to SSAS instance independently.

To isolate the connection problems, I tried connecting to Analysis Services from SSMS and still was unable to login into the VM.

Using Windows Authentication option, I got the following error

TITLE: Connect to Server
------------------------------
Cannot connect to <ipV4 address of Azure VM>.
------------------------------
ADDITIONAL INFORMATION:
Authentication failed. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
No credentials are available in the security package (Microsoft.AnalysisServices.AdomdClient)
------------------------------
BUTTONS:
OK
------------------------------

When using Microsoft Entra password and Microsoft Entra MFA authentication options, got the same error both times

TITLE: Connect to Server
------------------------------
Cannot connect to <ipv4 address of Azure VM>.
------------------------------
ADDITIONAL INFORMATION:
The integrated security 'ClaimsToken' is not supported for native connections. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
BUTTONS:
OK
------------------------------

I have tested and confirmed the Network Security Group permissions for Azure VM and Windows Firewall permissions are correct as I'm able to ping and connect to the VM using my RDP.

Please help!

Answer 1

You can't make a Windows auth connection unless the SSAS VM has been joined to the domain (or trusts the domain) you are connecting from.

Is the SSAS VM a member server in the same Windows domain that the client is in?

For the second option, it looks like you're trying to use one of the Active Directory options to connect. That refers to Azure Active Directory (now Microsoft Entra ID).

Note also that the ability to ping isn't really relevant. You need to be able to connect TCP on 2383.