SSMS 2017 Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal'

Tyler Moon picture Tyler Moon · Aug 13, 2018 · Viewed 14k times · Source

I recently installed Microsoft SQL Server Management Studio 2017.5 in order to connect to some Azure resources. When attempting to connect to any db (including my localhost) I get an error saying:

'Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=14.0.0.0,Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.

I have looked in the C:\Windows\assembly\GAC directory and do not see the assembly there as I believe it should be.

Is there some way I can either download the assembly or repair ssms?

UPDATE:

After many hours of struggling I found a procedure to solve this issue.

  1. Uninstall SSMS completely
  2. Delete the C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio directory
  3. Reinstall SSMS 17.5 and it should work now.

Looks like its a partial removal on upgrading from previously installed versions.

Answer

Tyler Moon picture Tyler Moon · Aug 13, 2018

After many hours of struggling I found a procedure to solve this issue.

1) Uninstall SSMS completely (and all versions of it)

2) Delete the C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio directory

3) Reinstall SSMS 17.5 and it should work now.

Looks like its a partial removal on upgrading from previously installed versions.