Analysis Services fails on a cluster with “An attempt was made to access a socket in a way forbidden by its access permissions”

The problem On a clustered SQL Server 2008 R2 installation, we have installed SQL Server in two separate instances on each cluster node. One Analysis Services resource will start, but the second one will not come online. The error is shown in the application event log and in the MSOLAP\LOG\msmdsrv.log Error(s): event id: 27 -…

0

Cannot reopen an Analysis Services Tabular Project the second time– error database already exists in the detached state

Using SQL Server 2012 Analysis Services running in Tabular mode, we get this error every time we open an existing Tabular Project solution. Even creating a new Analysis Services Tabular Project, closing it, and opening a second time again causes the same error. An error occurred while opening the model. Click Details for more information….

0

Cache Warming on an Analysis Services Tabular server

SQL Server 2012 introduces the new tabular BISM modeling in Analysis Services.  If you have many tabular databases deployed, or several large tabular databases, a server restart can cause a performance hit. The typical scenario is that when the Analysis Services service starts, it does not immediately load and warm the cache of the database…

0