question

ShainanHemrajani-5099 avatar image
0 Votes"
ShainanHemrajani-5099 asked OuryBa-MSFT commented

Deploy Azure Analysis services with Azure db connection in Yaml Pipeline

Hi,
I am creating YAML pipelines for Automating Deployment. I am deploying AAS using Powershell and need to figure out ways of configuring azure database connections.
I do not have username/password set up for db, it is accessed by AAD. I would like to configure connection without using usernames, may be some Identity or Service Principal option.

windows-server-powershellazure-sql-databaseazure-analysis-services
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShainanHemrajani-5099 Thank you for posting your question.
AAD is not supported in Azure Analysis Service to connect Azure SQL Server when no user is involved. You have to use username and password.

Regards,
Oury

0 Votes 0 ·

Thanks @OuryBa-MSFT for the Response.

Can you direct to some documentation for setting this up. So basically deployment of AAS with Sql connections being updated.

0 Votes 0 ·

And also one more question does AAS try to connect to sql while deployment itself?
If not then can I not configure AAS to just use AAD while connecting to sql db. I would be doing my refreshes using ADF which has a identity assigned to sql db anyway.

0 Votes 0 ·
OuryBa-MSFT avatar image OuryBa-MSFT ShainanHemrajani-5099 ·
0 Votes 0 ·

1 Answer

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello @ShainanHemrajani-5099

AAS will not let you connect to a DB without user/password settings.

Regarding the setup you can see more information here:
https://azure.microsoft.com/es-es/blog/using-azure-analysis-services-over-azure-sql-db-and-dw/

and how to create the first data model in AAS:
https://azure.microsoft.com/es-mx/blog/first-azure-as/

Hope this information helps with what you want to achieve,
Best regards,

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.