question

wi11iamr avatar image
wi11iamr asked

Process AAS Tabular Cube from OnPrem SQL Agent in different domain using Proxy Account

I have an Azure Analysis Services (AAS) instance with a tabular cube using Azure Active Directory (AAD) for authentication.

I also have an OnPrem SQL Server on a separate domain serving this AAS tabular cube.

(Integrating these 2 domains is not on the cards I'm afraid - IT has their reasons)

As I don't have an Azure SQL Server in place, I have to schedule the refresh of this cube from my OnPrem SQL Server.

In SSMS when connecting to the AAS instance, I can easily process the cube.

The SQL Agent job on my OnPrem server has a "SQL Server Analysis Services Command" step which I've set to Run As using a Proxy Account. this job fails with the following error summary:


"Executed as user: MyDomain\My.UserAccount

Authentication failed: User ID and Password are required when user interface is not available."


The issue undoubtedly is that my Proxy Account is setup using a Login/Credential from my OnPrem domain. There is no option to enter credentials from my Azure Active Directory.

Any suggestions on how I might go about scheduling the refresh of my AAS Tabular Cube either using SQL Agent to "push" the job, or possibly some alternate means in Azure to trigger a "pull" of the refresh?

analysis-servicesproxysql azureon-premises
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.