Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gsharrow
Frequent Visitor

Can not gateway data source using a DNS entry

 

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?

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors