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

What permissions are needed to create new objects in an Analysis Services database?

  To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the source code which throws the error to see what conditions it…

1

Visual Studio 2010 solution build process give a warning about indirect dependency on the .NET Framework assembly due to SSIS references

Here’s how I saw the problem… Install SQL Server 2005. Afterwards, Install SQL Server 2008. (Integration Services or Management tools features are enough usually) Install your favorite new tool Visual Studio 2010. Create or Open a solution for your C# or VB application. The Solution properties should target the “.Net Framework 3.5” to have this…

8