Windows 更新后 SQL Server Management Studio 将无法工作
今天早上上班时，我的电脑（Win7 x64）被 Windows 更新强制重启。现在，SQL Server Management Studio (SQL Server 2008 r2) 在连接到数据库并尝试展开树视图时失败，引用如下：
无法将“System.__ComObject”类型的 COM 对象强制转换为接口 输入“Microsoft.VisualStudio.OLE.Interop.IServiceProvider”。这 操作失败，因为 COM 组件上的 QueryInterface 调用 对于 IID 为“{6D5140C1-7436-11CE-8034-00AA006009FA}”的接口 由于以下错误而失败：不支持此类接口 （HRESULT 异常：0x80004002 (E_NOINTERFACE)）。 （Microsoft.VisualStudio.OLE.Interop）
夜间安装了以下更新：
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 生成资源管理器更新 (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)
所以，相当多。 事件查看器没有显示任何错误（无论如何，与此无关）并且所有更新均已成功安装。我现在有点被困在这里，我看过一些建议重新注册 DLL 的文章，但到目前为止还没有奏效。
非常欢迎任何帮助！
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:
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:
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)
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.
Any help would be most welcome!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
终于找到解决办法了！
由于某些非常奇怪的原因，似乎 Internet Explorer 是罪魁祸首。
C:\Program Files\Internet Explorer或c:\Program Files (x86)\Internet Explorer。regsvr32 /u ieproxy.dll（如果未加载，这可能会引发错误）regsvr32 ieproxy.dll这对我来说是成功的（实际上，我注册了/多注销一次，但这应该没什么可说的吧？）！
希望这对任何人都有帮助！
Finally found a fix!
Seems like Internet Explorer is the culprit, for some very strange reason.
C:\Program Files\Internet Explorerorc:\Program Files (x86)\Internet Explorerif you have Win x64.regsvr32 /u ieproxy.dll(this might throw an error if it isn't loaded)regsvr32 ieproxy.dllThis did the trick for me (actually, I registered/unregistered one extra time, but that shouldn't have anything to say?)!
Hope this helps anyone!