question

RichardBroida-9780 avatar image
0 Votes"
RichardBroida-9780 asked SaurabhSharma-msft commented

AAS Can't Connect to Azure SQL Managed Instance Public Endpoint

The documentation says AAS supports ASMI public endpoints as data sources, see https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource

We have enabled a public endpoint on our Azure Sql Managed Instance and allowed traffic from "Azure Cloud Service", all in accordance with the instructions here: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure#allow-public-endpoint-traffic-on-the-network-security-group

We connect SSMS to our AAS instance, open the Connection properties dialog for our AAS database, open the connection string properties, enter the ASMI public endpoint as the server name, and enter the name and password of an ASMI login. If we hit the Test Connection button, the test succeeds. The AlwaysUseGateway property is set to False, and Impersonation is set to Service Account.

Then we close the Connection properties dialog and try to Process the AAS database. We get this error almost immediately:


Failed to save modifications to the server. Error returned: 'On-Premise Gateway is required to access the data source. Please install a unified gateway for the server XXXXX or disable AlwaysUseGateway setting if it's enabled.

Technical Details:
RootActivityId: abfb86f5-1405-4d69-a071-fb9b3e613646
Date (UTC): 8/10/2021 4:06:24 PM



Why are we getting this error?

azure-analysis-services
· 2
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 @richardbroida-9780,

Thanks for using Microsoft Q&A !!

I suggest you to please open a support ticket so that someone could look into your environment and provide a resolution. In case you have any limitations opening a support case please let me know.

Thanks
Saurabh

0 Votes 0 ·

Hi @richardbroida-9780,

Please let me know if you need any help.

Thanks
Saurabh

0 Votes 0 ·

0 Answers