Microsoft_Excel_2013_logo.svgRecently, I experienced an issue trying to get a new installation of Microsoft Excel 2016 to connect to SQL Server 2014 Analysis Services Multidimensional.  Whether I would try to connect directly from Excel, via the “From Other Sources” menu or via the Cube Browser in SQL Server Management Studio, I would receive an error that Excel was unable to connect to the database.

I verified that the service was running, firewall not blocking it, and credentials good.  Read on for the solution to this issue.

Continue reading