Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
480 questions
Can con connect to Azure Analysis Services from SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 93%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Mendes, Victor
1
Reputation point
Error -
==================================
Cannot connect to asazure://uksouth.asazure.windows.net/xxxxxxxxxxxxxx.
===================================
XML parsing failed at line 1, column 0: A document must contain exactly one root element.
.
Technical Details:
RootActivityId: 7a6e16f1-769b-4af4-8c91-b0fdd90382da
Date (UTC): 7/19/2021 9:24:55 PM (Microsoft Analysis Services)
Program Location:
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Azure Analysis Services
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,851 Reputation points Microsoft Employee Moderator2021-07-21T00:32:33.333+00:00 Hi @Mendes, Victor ,
Thanks for using Microsoft Q&A !!
Here are few recommendations -
- Please try to update the Analysis services client libraries - AMO and ADOMD from here.
- If you are using a proxy server then whitelist aszure://uksouth.asazure.windows.net and asazure.windows.net on the proxy settings.
Please let me know if you still face any issues.
Thanks
Saurabh -
Mendes, Victor 1 Reputation point
2021-07-28T11:25:45.543+00:00 Hi,
Thank you for the recommnedations, unfortunately we are stilling facing the same issues. Any other recommendations?Thanks
V -
Saurabh Sharma 23,851 Reputation points Microsoft Employee Moderator
2021-08-03T21:22:22.603+00:00 @Mendes, Victor I suggest you to please file a support ticket for someone to look into your issue. In case you have any limitations please let me know and I will help creating a one-time free support ticket for you.
Thanks
Saurabh -
Saurabh Sharma 23,851 Reputation points Microsoft Employee Moderator
2021-08-10T18:04:54.88+00:00
Sign in to comment
Sign in to answer