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.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Blog Home
Email Blog Author
About
OK
RSS for comments
RSS for posts
Atom
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
404.3
Analysis Services
Backup Restore
Error
ErrorMessage
Excel 2010
Integration Services
MDS
Oracle Connectivity
PowerPivot
Programming
Script
Security
SQL Server 2005
SQL Server 2008
SQLProfiler
SSAS
SSIS
Visual Studio 2010
VSTA
VSTFS
Windows
Monthly Archives
Archives
December 2011
(1)
August 2011
(1)
March 2011
(2)
February 2011
(1)
October 2010
(3)
September 2010
(1)
August 2010
(3)
March 2010
(1)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Jason's Technical Topics
Deploying MDS Samples in SQL Server 2012
Posted
5 months ago
by
Jason H - SQL
0
Comments
[This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team specializing in MDS] MDS ships 3 samples model packages in SQL Server 2012 (as of Release Candidate 0 timeframe) that you can use to show MDS and play around...
Jason's Technical Topics
MDS Services.svc web service gives HTTP Error 404.3 – Not Found after I just installed it successfully
Posted
9 months ago
by
Jason H - SQL
1
Comments
If you use a Windows server to host IIS, and you installed IIS as an additional feature after Windows was already installed for a while, its likely that if you try to use the SQL Server 2008 R2 or SQL Server “Denali” Master Data Services web service it...
Jason's Technical Topics
What are the @OlapEvent queries hanging around in my SQL Server?
Posted
over 1 year ago
by
Jason H - SQL
0
Comments
If you look at current activity in SQL Server 2005 or 2008 or 2008 R2, you may notice some some sessions coming from Analysis Services where last_wait_type is TRACEWRITE. For example, when you query like this: SELECT * FROM sys.dm_exec_requests; SELECT...
Jason's Technical Topics
What permissions are needed to create new objects in an Analysis Services database?
Posted
over 1 year ago
by
Jason H - SQL
0
Comments
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...
Jason's Technical Topics
SQL Profiler doubleclick does not open .trc files any more
Posted
over 1 year ago
by
Jason H - SQL
0
Comments
Whenever I double-click on a profiler trace *.trc file I get the error Unrecognized command line argument. All command line arguments will be ignored. ..Please run 'profiler.exe -?' to see a list of valid command line arguments. I suspect...
Jason's Technical Topics
List of SQL Server Feature Packs
Posted
over 2 years ago
by
Jason H - SQL
0
Comments
There are so many SQL Server feature packs, and its hard to use search and see the whole list. I tried to compile that list here, with the latest copy at the top of each section. Let me know if I missed any :-) Generally, the packs are the same set...
Jason's Technical Topics
Package would not open in BIDS or run from DTExec when objects with expressions existed in the design
Posted
over 2 years ago
by
Jason H - SQL
1
Comments
The Funny Symptom This was a very strange case. Only one SSIS package would not load. All the other packages we had loaded fine. It would fail to open in BIDS, and failed when running it from the DTExec.exe command line with similar errors. The...
Jason's Technical Topics
Analysis Services - Orphaned SIDs cause error "No mappings between account name and security was done"
Posted
over 2 years ago
by
Jason H - SQL
3
Comments
When trying to add a user to the administrators role of Analysis Services 2005 or 2008 or 2008R2 The following error occurs: "The following system error occurred: No mapping between account names and security IDs was done. .(Microsft.AnalysisServices...
Jason's Technical Topics
Oracle Error when connecting from PowerPivot for Excel 2010 “Connection not open”
Posted
over 2 years ago
by
Jason H - SQL
5
Comments
Today we got this error when using 32-bit Excel and the PowerPivot addin to connect to Oracle Express. The full stack of the error appears when you expand the [Details >> ] button Error Message: ============================ ORA-06413: Connection...
Jason's Technical Topics
VSTFS error when running the Analysis Services processing job “There are currently no logon servers available”
Posted
over 2 years ago
by
Jason H - SQL
0
Comments
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...
Jason's Technical Topics
VSTA setup and configuration troubles for SSIS 2008 and R2 installations
Posted
over 2 years ago
by
Jason H - SQL
6
Comments
SSIS 2008 Uses VSTA 9.0 to edit Script Tasks and Script Task (in Control Flow) and Script Components (in Data flow tasks). VSTA stands for Visual Studio for Team Applications. It should look like this… and when you click the “Edit Script…” button...
Jason's Technical Topics
Visual Studio 2010 solution build process give a warning about indirect dependency on the .NET Framework assembly due to SSIS references
Posted
over 2 years ago
by
Jason H - SQL
6
Comments
Here’s how I saw the problem… Install SQL Server 2005. Afterwards, Install SQL Server 2008. (Integration Services or Management tools features are enough usually) Install your favorite new tool Visual Studio 2010. Create or Open a solution for your C#...
Jason's Technical Topics
The file exists…. no, but really the Restore failed
Posted
over 2 years ago
by
Jason H - SQL
0
Comments
If you try to restore an SSAS 2008 .abf backup file to an SSAS 2005 instance, you will get the error TITLE: Microsoft SQL Server Management Studio ------------------------------ The following system error occurred: The file exists. . (Microsoft...
Page 1 of 1 (13 items)