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

Question

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 1

For me upgrading to latest version 17.9.1 did help. Upgrade details can be found at following Microsoft page: https://docs.microsoft.com/en-gb/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 You can download the SQL Server Management Studio 17.9.1 Upgrade Package (upgrades 17.x to 17.9.1) and install it. Cheers.

Answer 2

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.