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…

0

Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."

  Lots of similar errors during processing Analysis Services processing (on Adventureworks DW cube in my example) can fail with this error “OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.” In SQL OLEDB terms HY008 means DB_E_CANCELED (aka your query was cancelled purposefully by the caller) If you get lucky, you can…

11

The file exists…. no, but really the Restore failed

If you try to restore an SSAS 2008 .abf backup file to an SSAS 2005 instance, you will get the error TITLE: Microsoft SQL Server Management Studio —————————— The following system error occurred:  The file exists. . (Microsoft SQL Server 2005 Analysis Services) —————————— BUTTONS: OK —————————— The solution: 1. Restore to SSAS 2008 instead….

0