SSMS 18.1 BUG - An exception has been encountered. This may be caused by an extension
Vitaly Bruk
Tech Lead | Senior Consultant | Data Architect & Performance Engineer | SQL Server, Azure SQL, AWS RDS DBA | Data Strategy & Optimization Expert at Madeira Data Solutions
Most of the new apps have problems and we take that into consideration before installation. Unfortunately, a new SQL Server Management Studio (SSMS) is not an exception.
If you recently installed a new SSMS 18.1, you are probably may be faced with an issue when trying to drag and drop any table from the object explorer to the query window, instead of not to type out the table name.
The error is: "An exception has been encountered. This may be caused by an extension".
This is a very annoying error because the SSMS is freezing and not responding (even for mouse clicks OK on the error message), and we need to kill the SSMS process, in case we want to continue working. That really can ruin all ours today's work, if we not save one in a while, and no available fix for that now!
Microsoft response is: "Issue has been identified and a fix is being made. It will be rolled out with the next update of SSMS 18".
So, no available fix - true, but let's do something else and still save our work! Next time, instead of killing SSMS when the error window pops up again:
- just press ENTER or ESC button on the keyboard and it un-freeze;
- save your work;
- close the window and open it in a new one;
- back to the work.
Hope it's helpful!
....at least until further fix. ??
ThreatCure Co-Founder & Director Engineering
1 年I am getting this error recently last month after windows update, I don't know what was in windows update. The error keeps coming and does not allow me to write any query. Only Enter key is working in the query editor. Then I installed 19.1 version of SSMS, and still same issue. Still finding the resolution for this problem. https://stackoverflow.com/questions/76506073/ssms-an-exception-has-been-encountered-you-can-get-more-in-file-path-appenv?noredirect=1#comment134895747_76506073 Let me know please, if you have any update on this. Thanks
--
5 年Fixed in version 18.2: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Program management; Multi-cloud data integration; Customized software for small-medium organizations. LIMS Environmental for water testing; EQQ? for business intelligence.
5 年Great. Thanks for the work-around