The Curious Engineer

All blogs / Databases

Jason's Technical Topics

learn.microsoft.com/en-us/archive/blogs/jason_howell

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.

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
25 from 15 Mar 2010 to 1 Oct 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/jason_howell/feed.xml

2014 2

  1. What is the RPC and RPC Out option on a SQL Server linked-server?
  2. SSIS error when deploying from VS 2013 to SSISDB in SQL 2012

2013 5

  1. Analysis Services fails on a cluster with “An attempt was made to access a socket in a way forbidden by its access permissions”
  2. Cannot reopen an Analysis Services Tabular Project the second time– error database already exists in the detached state
  3. Cache Warming on an Analysis Services Tabular server
  4. Script Component Recompile in SQL Server 2012 Integration Services (SSIS) to refresh metadata
  5. How do I ensure Analysis Services client TCP connectivity is encrypted?

2012 8

  1. Analysis Services Synchronization fails with permissions error
  2. SQL 2012 Data Mining Add-in for Office 2013 prerequisites error
  3. 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
  4. Enabling logging to troubleshoot MDSModelDeploy.exe
  5. How to patch SQL Server 2012 Setup with an updated setup package (using UpdateSource to get a smart setup)
  6. Analysis Services Stops Accepting New Connections –Processing commit locks hurt
  7. Error from AS client tools - "Property name was not recognized, 'APP'"
  8. Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."

2011 3

  1. Deploying MDS Samples in SQL Server 2012
  2. What permissions are needed to create new objects in an Analysis Services database?
  3. SQL Profiler doubleclick does not open .trc files any more

2010 7

  1. List of SQL Server Feature Packs
  2. Analysis Services - Orphaned SIDs cause error "No mappings between account name and security was done"
  3. Oracle Error when connecting from PowerPivot for Excel 2010 “Connection not open”
  4. VSTFS error when running the Analysis Services processing job “There are currently no logon servers available”
  5. VSTA setup and configuration troubles for SSIS 2008 and R2 installations
  6. Visual Studio 2010 solution build process give a warning about indirect dependency on the .NET Framework assembly due to SSIS references
  7. The file exists…. no, but really the Restore failed