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.
Looks like its a partial removal on upgrading from previously installed versions.
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.