Has anyone successfully connected to a VM in Azure running SQL 2012 AS for Multidimensional and Data Mining from an on-prem PC using the Excel Data Mining Add-on?
I understand that SSAS requires Windows Authentication - and you have to install the HTTP IIS service to get access via basic authentication. But before I start that process, I'd first like to hear if anyone has actually done it.
Or, a better question might be; Does the Excel Data Mining Add-on work via the HTTP connection to SSAS?
As we know, SQL Server Analysis Services only supports Windows Authentication. Excel Data Mining Add-in can connect to a SSAS instance, to establish an HTTP connection to a SSAS server, we can use the ISAPI extension (msmdpump.dll) which runs in Internet
Information Services (IIS) as the HTTP listener.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.