I am having trouble setting up a gateway connection to a on premise SSAS server via the gateway. I can can create connections using the SSAS server name or IP address, but cannot using the DNS entry (which works fine in desktop, SSMS, etc.) The on-prem server that has the gateway installed can resolve the DNS name via ping.
Here is the error (NOTE: I changed the server name below in the error message output for security reasons)
Unable to connect: We encountered an error while trying to connect to Stg-XXX-YYY.ABCCORP.com. Details: "The connection to the Analysis Services instance timed out or was lost. Ensure that the server and the 'SQL Browser' service are running."Hide details
| Activity ID: | 7f4fde88-a973-4a2a-ec5b-b5eb0f9c2143 |
| Request ID: | cf6f8571-3664-971e-0428-d22fde0f2bfd |
| Cluster URI: | https://wabi-us-north-central-redirect.analysis.windows.net |
| Status code: | 400 |
| Error Code: | DM_GWPipeline_Gateway_AdomdConnectError |
| Time: | Thu Sep 07 2017 12:53:31 GMT-0500 (Central Daylight Time) |
| Version: | 13.0.2278.219 |
thoughts?
