question

MSTechie-7364 avatar image
1 Vote"
MSTechie-7364 asked LukasYu-msft commented

On-premises SQL SSAS connect to Azure SQL DB as datasource using Azure AD authentication ?

Can On-premises SQL SSAS connect to Azure SQL DB as datasource using Azure AD authentication ?

I am using VS2019 with an SSAS project , but when i click on new data source, i dont get Azure AD authentication option , but only get SQL and Windows authentication.

Windows Authentication is not supported in Azure SQL PaaS . So we wanted to use Azure AD Authentication from on-prem SSAS to Azure SQL , but is this feature supported ?

Please help

azure-active-directoryazure-sql-databasesql-server-analysis-services
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.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Are you creating Multidimensional Cube On Prem or are you trying Tabular model On Prem?

· 1
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.

We did not hear from you back, did you resolve this issue ?

0 Votes 0 ·
JakubK-7942 avatar image
0 Votes"
JakubK-7942 answered

the driver you use needs to support the 'Authentication = "Active Directory Integrated"' setting. Manually create the connection string if the gui for the driver doesnt show you that drop down.

I tried to setup an example for a screenshot but the 2019 ssas extension is really buggy and wont even install

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.

rgfuller-2241 avatar image
0 Votes"
rgfuller-2241 answered rgfuller-2241 edited

In the Connection manager, select .Net Providers\SqlClient Data Provider as the Provider. Then under Authentication select Active Directory Password Authentication, then you can enter your fully-qualified Azure user name, like user@domain.tld, and password.

In the Data Source Designer, on the Impersonation Information tab, select use the service account.


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.