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

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

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

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

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

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

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

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

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

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

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

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

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