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

Posted by: Max Chen | in SQL Server | 1 year, 11 months ago |

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

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

  1. 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
Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2023
2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 4

DigitalOcean 1

Django 1

English 3

Excel 5

FUN 4

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

MDX 1

Machine Learning 2

Manufacture 1

Master Data Service 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 22

SEO 2

SQL Server 53

SQL Server Analytics Service 1

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

投資入門 1

投資心得 2

時間管理 1

總體經濟 2

自我成長 3

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

Max Chen (159)

Feeds

RSS / Atom

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

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.