CODEWITHSUNDEEP
azure-active-directoryssasazure-virtual-machineazure-virtual-network
Ankur
Ankur

Reputation: 41

Two Azure SQL VM with SQL Server and Analysis Server installed on them, I want to access SSAS on one VM from another

I have two Azure SQL VM with SQL Server and Analysis Server installed on them, I want to access SSAS on one VM from another using an Authentication Mechanism which will allow me to use only one cred using SSMS to access it.

I am able to access SQL Server on these VMs using SQL Authentication, while for SSAS I ma having problem to understand how to give one windows user access on another machine.

While VM show they are in same VNET, while when I try to add another VM windows user to another it says unable to find.

Any leads

Upvotes: 0

Views: 231

Answers (1)

Nancy Xiong
Nancy Xiong

Reputation: 28264

You could specify whether Windows Authentication is used to connect to a SQL Server Analysis Services server. Also, Ensure that the account you are connecting with is a member of the Server Administrator role on another Azure VM. Before this, you need to add the two machines in the same AD domain. For more information, see Grant server admin rights to an Analysis Services instance.

For more references, you could get the details about connecting from client applications (Analysis Services).

Hope this could help you.

Upvotes: 1

Related Questions