Tabular Model Designer - An error occurred while opening the model on the workspace database. Reason: The type initializer for 'Microsoft.AnalysisServices.BackEnd.DAXServices' threw an exception.

Question

_{Wednesday, January 16, 2019 4:57 PM}

This error has been killing my workday.

I've installed Visual Studio Community and SSDT several times in a variety of different ways and I continue to get this error whenever I try to create a new Analysis Services Project.  I've also reinstalled SSMS several times. Does anyone know how to fix this?  Please help!

Thanks!!

============================ Error Message:

An error occurred while opening the model on the workspace database. Reason: The type initializer for 'Microsoft.AnalysisServices.BackEnd.<g class="gr_ gr_149 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="149" id="149">DAXServices</g>' threw an exception.

Call Stack:

   at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged, Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
   at Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance(UInt32 grfCreateDoc, String pszMkDocument, String pszPhysicalView, IVsHierarchy pvHier, UInt32 itemid, IntPtr punkDocDataExisting, IntPtr& ppunkDocView, IntPtr& ppunkDocData, String& pbstrEditorCaption, Guid& pguidCmdUI, Int32& pgrfCDW)

============================

All replies (3)

_{Wednesday, January 16, 2019 8:17 PM}

I was able to fix it.  I'm going to reply to my posting in case it helps someone else down the road.  

The solution that worked for me was to uninstall both Visual Studio and SMSS.  When I uninstalled SMSS, I saw some files that gave the appearance that I might have some crap left over from a prior installation of SMSS, so I wonder if that was the culprit.  Anyway, I uninstalled SMSS as well.

A suspicion that a friend and I had is that the sequence of the installation might also be related to the problem.  So, after rebooting Windows, we installed SMSS first (I think it had been installed with VS before), and then installed VS.  Then, after opening VS, I went to the Extensions and Updates menu under Tools where I installed SSAS (and SSRS, which I also needed).

After completing the installation, I rebooted once more and tried VS again.  I was able to start a new Analysis Services project as well as open an existing SSAS project.  Finally!!  I hope this helps someone!

_{Thursday, January 17, 2019 5:01 AM}

Hi Satterwhite,

You are so sweet and we appreciate you taking the time to share this solution for us. I believe that will helpful some members to troubleshoot issue.

So, could you please mark your solution as answer? For that, members will catch it as soon as possible.

Thank you for your understanding.

Br

May

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]

_{Wednesday, August 7, 2019 3:18 PM | 1 vote}

You don't need to uninstall anything!

You can instead delete the Workspace Database - this should solve the issue.  

The Workspace Database is the cube with the GUID at the end - e.g. MyTabularDatabase_USERNAME_c8eb12d6-f81f-4166-a0f1-d0f293af9164