Sign in
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.
Common Tasks
Blog Home
Email Blog Author
About
OK
RSS for comments
RSS for posts
Atom
Search Form
Tag Cloud
404.3
Analysis Services
Backup Restore
Blocking
Error
ErrorMessage
Excel 2010
ForceCommitTimeout
Integration Services
Locks
MDS
OLAP
PowerPivot
Processing
Security
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
SQLProfiler
SSAS
SSIS
Timeout
Visual Studio 2010
VSTA
VSTFS
Monthly Archives
Archives
March 2013
(1)
February 2013
(1)
December 2012
(1)
November 2012
(1)
September 2012
(2)
August 2012
(1)
July 2012
(1)
June 2012
(2)
December 2011
(1)
August 2011
(1)
March 2011
(2)
February 2011
(1)
October 2010
(3)
September 2010
(1)
August 2010
(3)
March 2010
(1)
Browse by Tags
MSDN Blogs
>
Jason's Technical Topics
>
All Tags
>
analysis services
Tagged Content List
Blog Post:
SQL 2012 Data Mining Add-in for Office 2013 prerequisites error
Jason H - SQL
If you try to install the Data Mining Add-in into Office 2013 the setup may fail with the prerequisite error. This may happen if you are using the ClickToRun install of Office, chances are you still have Office 2010 or another version side-by-side, as ClickToRun doesn’t uninstall previous versions...
on
29 Nov 2012
Blog Post:
Analysis Services Stops Accepting New Connections –Processing commit locks hurt
Jason H - SQL
This common blocking symptom really can cause trouble if you get caught off guard. When you process an Analysis Services object, like FullProcess on a database or cube, near the end of processing is the phase where it needs to swap the old files out and replace it with the new files a lock is needed...
on
3 Jul 2012
Blog Post:
Error from AS client tools - "Property name was not recognized, 'APP'"
Jason H - SQL
Every time I try to connect to my SQL Server 2012 Analysis Services, from Management Studio or SQL Profiler I kept getting this error popup and I cannot connect. "Property name was not recognized, 'APP'" I figured it out… I ran process monitor and found that MSOLAP8 had been registered...
on
11 Jun 2012
Blog Post:
Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."
Jason H - SQL
Lots of similar errors during processing Analysis Services processing (on Adventureworks DW cube in my example) can fail with this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008 ." In SQL OLEDB terms HY008 means DB_E_CANCELED (aka your query was cancelled purposefully by...
on
11 Jun 2012
Blog Post:
What permissions are needed to create new objects in an Analysis Services database?
Jason H - SQL
To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the source code which throws the error to see what conditions...
on
1 Mar 2011
Blog Post:
VSTFS error when running the Analysis Services processing job “There are currently no logon servers available”
Jason H - SQL
Today we got a fun one… In Visual Studio Team Foundation Server 2010, the server has a SQL Server database(s), an SQL Server Analysis Services database (cube), and several reports on top of the cube. There were two symptoms: 1. Data was not refreshed when using the Reports in VSTFS Admin...
on
30 Aug 2010
Page 1 of 1 (6 items)