Latest SSMS 18.11.1 breaks the Data Clasification. Get missing assembly error after updating

New

ToolingBugs

6 Comments

You must to comment

Muniswari Chilamkuri1 year ago

0 Reports0

Matteo Taveggia2 years ago

0 Reports0

Kalle Niemitalo2 years ago

0 Reports0

I too get this error on SSMS 18.11.1. The Microsoft.InformationProtection assembly is referenced by "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Microsoft.SqlServer.Management.ThreatDetection.dll", but none of the following commands finds any version of Microsoft.InformationProtection: dir /a /b /s "C:\Program Files\Microsoft SQL Server\Microsoft.InformationProtection.dll" dir /a /b /s "C:\Program Files (x86)\Microsoft SQL Server\Microsoft.InformationProtection.dll" dir /a /b /s "C:\Windows\Microsoft.NET\assembly\Microsoft.InformationProtection.dll" Error details: =================================== Could not load file or assembly 'Microsoft.InformationProtection, Version=1.10.98.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.Management.ThreatDetection) ------------------------------ Program Location: at Microsoft.SqlServer.Management.ThreatDetection.DataClassification.DataClassificationOpenActionHandler.PerformAction(String actionMoniker, IContext context) at Microsoft.SqlServer.Management.TaskManagementService.Microsoft.SqlServer.Management.ITaskLauncherService.PerformAction(String actionMoniker, IContext context) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ActionMenuItem.Invoke() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.MenuInvokedHandler(Object sender, EventArgs args)

Ian Singlehurst2 years ago

0 Reports0

I get the same error. The steps are easy; right click on a database in SSMS (on a SQL 2019 Server you are connected to), go to Tasks > Data Discovery and Classification > Classify Data... and you get the error. Could not load file or assembly 'Microsoft.InformationProtection, Version=1.10.98.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.Management.ThreatDetection) It happens after upgrading to SSMS 18.11.1-if I uninstall and install the previous version, it works, but then breaks after upgrading.

Madhumita Tripathy3 years ago

0 Reports0

Hi Colin - could you please share steps to recreate and describe exactly what you're doing when the error appears? Thank you!

Erin Stellato3 years ago

0 Reports0

Hi - can you please share steps to recreate and describe exactly what you're doing when the error appears? Thank you!