[Resolved]How to solve the access issue for the communication between Azure App Service (hybrid connection port 2383 and 80) to SSAS On-Premise

Sachin K 0 Reputation points
2023-12-18T11:02:39.2966667+00:00

We are setting up a communication between on-premise ssas and azure app service.
The SSAS is responding on 2383 and for external communication we have created http access as mentioned in https://learn.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions&viewFallbackFrom=sql-server-2017.

Hybrid connection is set in the App service for the on-premise server (both port 80 and port 2383).

Can access http://localhost:80/OLAP/msmdpump.dll from the browser within the server but, outside it's 500 internal server.

Also, can not connect to [http://localhost:80/OLAP/msmdpump.dll] from SSMS.

Any help in this regard?

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,974 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ajkuma 28,036 Reputation points Microsoft Employee Moderator
    2023-12-19T20:34:26.33+00:00

    To support the Hybrid Connections it's configured with, HCM requires: TCP access to Azure over port 443.

    To fetch more details about the issue and logs.
    Troubleshoot Hybrid Connection Issues - Windows/Linux

    Just to highlight, in App Service, the tcpping command-line tool can be invoked from the Advanced Tools (Kudu) console. This tool can tell you if you have access to a TCP endpoint, but it doesn't tell you if you have access to a Hybrid Connection endpoint. When you use the tool in the console against a Hybrid Connection endpoint, you're only confirming that it uses a host:port combination.

    Azure App Service Hybrid Connections | Troubleshooting
    Troubleshooting Hybrid Connections with Logging

    --You may always leverage App Service diagnostics from Azure Portal> Navigate to your App Service app in the Azure Portal.

     In the left navigation, click on Diagnose and solve problems - Review and run – Network troubleshooter and ““Configuration and Management”  (IP address configuration).


  2. Sachin K 0 Reputation points
    2024-01-09T11:23:42.04+00:00

    The issue is resolved after updating the hot chocolate graphql libraries to latest version and creating a public IP to point to my local on premise IP.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.