Windows 更新后 SQL Server Management Studio 将无法工作 [英] SQL Server Management Studio won't work after Windows Update

问题描述

今天早上上班，我的电脑 (Win7 x64) 被 Windows 更新强制重启.现在，SQL Server Management Studio (SQL Server 2008 r2) 在连接到数据库并尝试展开树视图时失败，引用:

Came to work this morning, my PC (Win7 x64) had force rebooted by Windows Update. Now, SQL Server Management Studio (SQL Server 2008 r2) fails when connecting to a database and trying to expand the tree view, citing:

无法将类型为System.__ComObject"的 COM 对象转换为接口输入Microsoft.VisualStudio.OLE.Interop.IServiceProvider".这个操作失败，因为 COM 组件上的 QueryInterface 调用对于 IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' 的接口由于以下错误而失败:不支持此类接口(来自 HRESULT:0x80004002 (E_NOINTERFACE) 的异常).(Microsoft.VisualStudio.OLE.Interop)

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such interface supported (Exception from HRESULT:0x80004002 (E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)

以下更新是在夜间安装的:

The following updates were installed during the night:

Microsoft Office 2007 系统安全更新 (KB2553090)
Microsoft Visual Studio 2010 Service Pack 1 Web 平台工具更新 (KB2548139)
Microsoft Visual Studio 2010 Service Pack 1 报告查看器更新 (KB2549864)
Microsoft Visual Studio 2010 Service Pack 1 TFS Build Explorer 更新 (KB2522890)
Microsoft Office Excel 2007 安全更新 (KB2553073)
Microsoft Office Groove 2007 安全更新 (KB2552997)
Microsoft Office Outlook 2007 垃圾邮件过滤器更新 (KB2553110)
适用于基于 x64 的系统的 Windows 7 安全更新 (KB2570947)
Microsoft Visual Studio 2010 Service Pack 1 更新 (KB2547352)
Microsoft Office 2007 系统安全更新 (KB2553089)
Microsoft Visual Studio 2010 Service Pack 1 更新 (KB2529927)
2007 Microsoft Office System 安全更新 (KB2553074)
Microsoft Office Outlook 2007 更新 (KB2583910)
Microsoft Office 2007 系统安全更新 (KB2584063)
适用于基于 x64 的系统的 Windows 7 更新 (KB2616676)
Windows 恶意软件删除工具 x64 - 2011 年 9 月 (KB890830)

Security Update for Microsoft Office 2007 System (KB2553090)
Update for Microsoft Visual Studio 2010 Service Pack 1 Web Platform Tools (KB2548139)
Update for Microsoft Visual Studio 2010 Service Pack 1 Report Viewer (KB2549864)
Update for Microsoft Visual Studio 2010 Service Pack 1 TFS Build Explorer (KB2522890)
Security Update for Microsoft Office Excel 2007 (KB2553073)
Security Update for Microsoft Office Groove 2007 (KB2552997)
Update for Microsoft Office Outlook 2007 Junk Email Filter (KB2553110)
Security Update for Windows 7 for x64-based Systems (KB2570947)
Update for Microsoft Visual Studio 2010 Service Pack 1 (KB2547352)
Security Update for Microsoft Office 2007 System (KB2553089)
Update for Microsoft Visual Studio 2010 Service Pack 1 (KB2529927)
Security Update for the 2007 Microsoft Office System (KB2553074)
Update for Microsoft Office Outlook 2007 (KB2583910)
Security Update for Microsoft Office 2007 System (KB2584063)
Update for Windows 7 for x64-based Systems (KB2616676)
Windows Malicious Software Removal Tool x64 - September 2011 (KB890830)

所以，相当多.事件查看器没有显示任何错误(无论如何都不会)并且所有更新都已成功安装.我现在有点卡在这里，我看过一些建议重新注册 DLL 的文章，但到目前为止还没有奏效.

So, quite a bit. The Event Viewer shows no errors (not regarding this, anyway) and all updates were successfully installed. I'm kind of stuck here right now, I've seen some articles recommending re-registering DLLs, but so far that hasn't worked.

欢迎任何帮助！

推荐答案

终于找到了解决办法！

似乎 Internet Explorer 是罪魁祸首，原因很奇怪.

Seems like Internet Explorer is the culprit, for some very strange reason.

• 在管理模式下启动命令行.
• 如果您有 Win x64，请转到 C:\Program Files\Internet Explorer 或 c:\Program Files (x86)\Internet Explorer.
• 执行regsvr32/u ieproxy.dll(如果未加载，这可能会引发错误)
• 执行regsvr32 ieproxy.dll

• Launch command line in administrative mode.
• Go to C:\Program Files\Internet Explorer or c:\Program Files (x86)\Internet Explorer if you have Win x64.
• Execute regsvr32 /u ieproxy.dll (this might throw an error if it isn't loaded)
• Execute regsvr32 ieproxy.dll

这对我有用(实际上，我注册/取消注册了一次额外的时间，但这应该没什么好说的吧?)！

This did the trick for me (actually, I registered/unregistered one extra time, but that shouldn't have anything to say?)!

希望对大家有所帮助！

这篇关于Windows 更新后 SQL Server Management Studio 将无法工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！