DEV Community

Christoph Weigert
Christoph Weigert

Posted on • Originally published at christophweigert.com on

Visual Studio: Could not load file or assembly sqlmgmt.dll Analysis Services Processing Task

Today I wanted to deploy a multidimensional Analysis Services Solution to our test server, but Visual Studio crashed right after loading the Processing Task User Interface. The exception was: 'Could not load file or assembly sqlmgmt.dll Analysis Services Processing Task.'

One fix I stumbled across was to copy & paste files. If you are using Professional or Enterprise Edition, you need to change the first path accordingly.

Copy from:

C:\Program Files (x86)\Microsoft VisualStudio\2017\Community\Common7\IDE\Extensions\Microsoft\SQLCommon\140

to

C:\Program Files (x86)\Common Files\microsoft shared\SQL Server Developer Tools\140

Restart your Visual Studio, and you can redeploy your solution.

Some more time intense solutions are to reinstall the SSDT packages

SSDT 2012

SSDT 2014

References:

Could not load file or assembly sqlmgmt.dll Analysis Services Processing Task

Getting assembly error when attempting to process cube

Top comments (0)