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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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....
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...
Date: 03/15/2010