SSMS - Assembly error after upgrade to new version

1

I was running an upgrade on SSMS and it won't connect to the SQL Server after installation. I can connect to the SQL Server from SSMS on another server but not on the local one.

I'm getting the following message when I try to connect:

Could not load file or assembly 'Microsoft.AnalysisServices, Version=19.2.0.2, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (ObjectExplorer)

I tried uninstalling and reinstalling SSMS but I'm getting the same error. I'm hoping there's a fix that doesn't require a restart. This server only goes down for a couple hours a month for maintenance.

sql-server
ssms
.net-assembly
asked on Stack Overflow Aug 19, 2020 by alcor8 • edited Aug 19, 2020 by fuz

1 Answer

0

The issue is not with SSMS itself. The problem is with SQL_AS_AMO install. It seems like your Microsoft.AnalysisServices is corrupted no longer valid.

Download and reinstall the Analysis Services client libraries to repair your SQL_AS_AMO https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=azure-analysis-services-current (Look for the AMO link)

answered on Stack Overflow Aug 19, 2020 by vvvv4d

User contributions licensed under CC BY-SA 3.0