Error from AS client tools - "Property name was not recognized, 'APP'"
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: https://technet.microsoft.com/en-us/sysinternals/bb896645.aspx
Resolution…
Downloaded the matching MSOLAP provider from the matching feature pack download
- SQL 2005 https://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en
- SQLServer2005_ASOLEDB9.msi
- SQL 2008 https://www.microsoft.com/download/en/details.aspx?id=27596
- SQLSERVER2008_ASOLEDB10.msi
- SQL 2008 R2 https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=16978
- SQLSERVER2008_ASOLEDB10.msi
- SQL 2012 https://www.microsoft.com/en-us/download/details.aspx?id=29065
- SQL_AS_OLEDB.msi
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.