Every time I try to connect to my SQL Server 2012 Analysis Services, from Management Studio or SQL Profiler I kept getting this error popup and I cannot connect.
"Property name was not recognized, 'APP'"
I figured it out…
I ran process monitor and found that MSOLAP8 had been registered but the MSOLAP11 version of OLEDB Provider was not present which is what was needed to connect to SQL Server 2012.
Process Monitor works wonders… the free download is here: http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx
Downloaded the matching MSOLAP provider from the matching feature pack download
- SQL 2005 http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en
- SQL 2008 http://www.microsoft.com/download/en/details.aspx?id=27596
- SQL 2008 R2 http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=16978
- SQL 2012 http://www.microsoft.com/en-us/download/details.aspx?id=29065
Look for the OLEDB keyword in the downloads to find the right bitness (64-bit is x64, 32-bit is x86) of download for your client computer.