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 -…


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….


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…


Script Component Recompile in SQL Server 2012 Integration Services (SSIS) to refresh metadata

In SQL Server releases 2005-2008 R2 there is a programmatic approach to be able to dynamically change dataflow columns and their data types in a dataflow task from the SSIS programmatic APIs, and have a Script Component still work magically (most of the time). In Microsoft Customer Service and Support we saw this from time…


How do I ensure Analysis Services client TCP connectivity is encrypted?

SQL Server Analysis Services often deals with sensitive financial numbers, sales figures,  and strategic information used by businesses. Therefore it is natural to want to protect and encrypt data when is it queries to and fro from the Analysis Services over the TCP layers in Windows. I’m am going to talk about network traffic encryption…