spotfire web player analysis connecting to ms sql server analysis services cube authentication issue
in web player, my analysis is prompting for a uid/pwd to ssas cube. when a valid uid/pwd with appropriate access is entered the authenication still fails. analysis works fine in desktop client mode.
Is something not configured properly with our web player installation?
This has tripped me up before. I had to make sure the correct Microsoft SQL Server ADOMD.NET driver was installed on the server ... depending on your Spotfire version, this will be the Web Player Server (before v7.5), or the Node Server (v7.5 and up).
We are running SQL Server Analysis Services (SSAS) 2014, and the driver I needed was the Microsoft SQL Server 2012 ADOMD.NET driver. Not certain which one you will need, but I recall that several were available for easy download from Microsoft.