Jason's Technical Topics

A collection of technical situations and solutions I've run across while using SQL Server, focusing on SQL Analysis Services, SQL Integration Services, and plenty of other random topics.

What is the RPC and RPC Out option on a SQL Server linked-server?

Someone asked me this week - what are the relevance of the RPC and RPC Out settings on a linked...

Author: JasonHowell Date: 10/01/2014

SSIS error when deploying from VS 2013 to SSISDB in SQL 2012

An SSIS package has been developed in SSDT-BI Microsoft Visual Studio Professional 2013 (freely...

Author: JasonHowell Date: 09/30/2014

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

Author: JasonHowell Date: 07/24/2013

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

Author: JasonHowell Date: 07/22/2013

Cache Warming on an Analysis Services Tabular server

SQL Server 2012 introduces the new tabular BISM modeling in Analysis Services.  If you have...

Author: JasonHowell Date: 07/22/2013

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

Author: JasonHowell Date: 03/05/2013

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

SQL Server Analysis Services often deals with sensitive financial numbers, sales figures,  and...

Author: JasonHowell Date: 02/26/2013

Analysis Services Synchronization fails with permissions error

When you want to run Synchronization to copy an Analysis Services database from one server to...

Author: JasonHowell Date: 12/05/2012

SQL 2012 Data Mining Add-in for Office 2013 prerequisites error

If you try to install the Data Mining Add-in into Office 2013 the setup may fail with the...

Author: JasonHowell Date: 11/29/2012

Getting Error in an Excel 2010 PivotTable “The field that you are moving cannot be placed in that PivotTable area” when referring to PowerPivot data sources

We kept getting this error when attempt to drag and drop dimensions attributes into a PivotTable in...

Author: JasonHowell Date: 09/26/2012

Enabling logging to troubleshoot MDSModelDeploy.exe

In the situation where you are trying to deploy an MDS model via the package to your Master Data...

Author: JasonHowell Date: 09/13/2012

How to patch SQL Server 2012 Setup with an updated setup package (using UpdateSource to get a smart setup)

In SQL Server 2012, there is a new setup feature introduced which can apply a patch to SQL Server...

Author: JasonHowell Date: 08/28/2012

Analysis Services Stops Accepting New Connections –Processing commit locks hurt

This common blocking symptom really can cause trouble if you get caught off guard. When you process...

Author: JasonHowell Date: 07/03/2012

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

Author: JasonHowell Date: 06/11/2012

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

Author: JasonHowell Date: 06/11/2012

Deploying MDS Samples in SQL Server 2012

[This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team...

Author: JasonHowell Date: 12/15/2011

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

Author: JasonHowell Date: 03/01/2011

SQL Profiler doubleclick does not open .trc files any more

Whenever I double-click on a profiler trace *.trc file I get the error Unrecognized command line...

Author: JasonHowell Date: 02/18/2011

List of SQL Server Feature Packs

There are so many SQL Server feature packs, and its hard to use search and see the whole list. I...

Author: JasonHowell Date: 10/25/2010

Analysis Services - Orphaned SIDs cause error "No mappings between account name and security was done"

When trying to add a user to the administrators role of Analysis Services 2005 or 2008 or 2008R2...

Author: JasonHowell Date: 10/11/2010

Oracle Error when connecting from PowerPivot for Excel 2010 “Connection not open”

Today we got this error when using 32-bit Excel and the PowerPivot addin to connect to Oracle...

Author: JasonHowell Date: 09/02/2010

VSTFS error when running the Analysis Services processing job “There are currently no logon servers available”

Today we got a fun one… In Visual Studio Team Foundation Server 2010, the server has a SQL...

Author: JasonHowell Date: 08/30/2010

VSTA setup and configuration troubles for SSIS 2008 and R2 installations

SSIS 2008 Uses VSTA 9.0 to edit Script Tasks and Script Task (in Control Flow) and Script Components...

Author: JasonHowell Date: 08/18/2010

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

Author: JasonHowell Date: 08/18/2010

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

Author: JasonHowell Date: 03/15/2010