重装了系统以后,因为机器上的VS2010文件有问题,所以先装了SQL SERVER 2012,只有才安装了VS2010和VS2012。看起来都很正常,结果发现SSMS怎么都启动不了,重装SQL SERVER也不行,一直怀疑是卸载了什么关联的组件引起的。
DBA直接给了一个解决方案,马上就解决了。
• Start regedit.exe
• Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio
• Delete 11.0_Config
• Restart ssms.exe
There is a similar problem in this feedback to Microsoft, please refer to it:
http://connect.microsoft.com/VisualStudio/feedback/details/690773/after-installing-visual-studio-11-my-sql-server-denali-cannot-be-opened
参考文章里的一段话:
This happens after installing SQL Server 2012 (Code named "Denali CTP3") or later, running SSMS successfully, then (later) install VS11 Dev Preview, and then run SSMS.
Dev11 Preview improperly recognize SQL Server Denali SSMS as a version 11 application and it updates the current user’s setting in SSMS registry key during the setup. This issue occurs only when Dev11 Preview is installed after the installation of SSMS.
SQL Server 2012 SSMS has a built-in security and resiliency feature for any corrupted configuration in HKCU registry key. The corrupted registry keys can be simply deleted then SSMS automatically reconstructs it with correct values during the next startup procedure.
• Start regedit.exe
• Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio
• Delete 11.0_Config
• Restart ssms.exe
本文由VS软件圈(vssoft.net)发布,不代表VS软件圈立场,转载联系作者并注明出处:https://vssoft.net/vsazwt/VS2010anzhuangwenti/2020/0724/2676.html