The following system error ocurred:

Question

Hi,

An user is getting the error "The following system error ocurred: (blank)" while connecting to Analysis Services trough Excel.

It happens only from his computer, if I try the connection from my computer with his credentials I can access successfully.

Could be a firewall issue?
Thank you in advance

Answer 1

Hi @leonardo moreno salinas ,

Thanks for the ask and using Microsoft Q&A forum.

All connections to a server, regardless of type, require updated AMO, ADOMD.NET, and OLEDB client libraries to connect to and interface with an Analysis Services server. For SSMS, Visual Studio, Excel 2016 and later, and Power BI, the latest client libraries are installed or updated with monthly releases. However, in some cases, it's possible an application may not have the latest. For example, when policies delay updates, or Microsoft 365 updates are on the Deferred Channel.

Please make sure that the user has the latest client libraries. You can get the client libraries from here : Get the latest Client libraries

Also please note that

• The client libraries cannot connect to Azure Analysis Services through proxy servers that require a username and password.
• Excel users can connect to a server by using a Windows account, an organization ID (email address), or an external email address. External email identities must exist in the Azure AD as a guest user.

To check if it is related to network, then try to ping the server from user machine and see how it goes.

Here are few relevant forum threads where similar issue was discussed. Please have a look and see if those helps.

• https://stackoverflow.com/questions/2028837/cant-connect-to-analysis-services-via-excel
• https://stackoverflow.com/questions/40983137/excel-is-not-able-to-connect-to-analysis-server-2016-error-no-such-host-is-kn
• https://azure.microsoft.com/blog/connect-excel-to-an-azure-analysis-services-server/

Hope this info helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.