question

MendesVictor-6728 avatar image
0 Votes"
MendesVictor-6728 asked SaurabhSharma-msft commented

Can con connect to Azure Analysis Services from SSMS

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
· 4
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 @mendesvictor-6728,

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

0 Votes 0 ·

Hi,
Thank you for the recommnedations, unfortunately we are stilling facing the same issues. Any other recommendations?

Thanks
V

0 Votes 0 ·

@mendesvictor-6728 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

0 Votes 0 ·

@mendesvictor-6728,

Please let me know if you need any help creating a support ticket.

Thanks
Saurabh

0 Votes 0 ·

0 Answers