SQL Server--使用另一個Windows Account操作SSMS, 錯誤訊息 : 請輸入用於c:\program file\sql server management studio 18\common7\ide\ssms.exe

Please follow these steps to mitigate the issue:

1. Close all SQL Server Management Studio (SSMS) instances.
2. Locate your SSMS application file (exe). This is commonly found in C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE.
3. Open the file Ssms.exe.config in Notepad as Administrator.

4. Locate the AppContextSwitchOverrides node and append these two properties to the value.

   ;Switch.System.Windows.Interop.MouseInput.OptOutOfMoveToChromedWindowFix=true; Switch.System.Windows.Interop.MouseInput.DoNotOptOutOfMoveToChromedWindowFix=true

5.Save the config file and reopen SSMS.

Please refer to Workaround to move tabs to get more information about SSMS crashed when you re-dock tab. And there has one case is similar with you.

And we already tested the workaround in our side, it works well. If the workaround still not work, please check which version of Windows and SSMS you are using? If you are using Windows 10 (version 1809) or Windows Server (version 2019), please apply the fix in your environment to rosolve your issue. Please refer to February 16, 2021-KB4601558 Cumulative Update Preview for .NET Framework 3.5 and 4.7.2 for Windows 10, version 1809 and Windows Server, version 2019 to get more information.

參考來源: https://docs.microsoft.com/en-us/answers/questions/282990/ssms-crash-after-one-sql-query-window-pull-to-anot.html

tags: SQL Server

• ← SQLite--SQLite管理工具DB
• SQL Server--What is the db_datreader/db_datawriter/db_owner/... "Schema" Useage? →