Cant use SSMS 2012 after updating from 10.1 to 10.2

osumatt

I updated both SQL Compare & SQL Data Compare from 10.1 to 10.2.

I only have SQL 2012 installed on my machine and I am using SSMS 2012.

I connect to any server and as soon as I click on the server node in SSMS, it crashes. The only copy on my machine is version 9.5.0.547, located at C:\ProgramData\Red Gate\SIPFw

Please help soon, I can't use SSMS at all!


===================================

Error connecting to 'COMPUTERNAME'.

===================================

Could not load file or assembly 'RedGate.Shared.Utils, Version=9.5.0.543, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified. (RedGate.SharedSSMS)

---

Program Location:

at RedGate.SharedSSMS.Util.ReflectionUtils.GetType(String assemblyName, String typeName)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer.get_UrnType()
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#jYc(String #u6c)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#iYc(String #u6c)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#UXc(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer.#P7i(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer.#97c(Object #Zsf, TreeViewEventArgs #9Z)
at System.Windows.Forms.TreeViewEventHandler.Invoke(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorerControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.Control.SendMessage(Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.Control.ReflectMessageInternal(IntPtr hWnd, Message& m)
at System.Windows.Forms.Control.WmNotify(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Application.ParkingWindow.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
at System.Windows.Forms.Control.DefWndProc(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorerControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at System.Windows.Forms.Control.SendMessage(Int32 msg, Int32 wparam, IntPtr lparam)
at System.Windows.Forms.TreeView.set_SelectedNode(TreeNode value)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorerControl.AddHierarchy(SqlOlapConnectionInfoBase info, IExplorerHierarchy hierarchy)
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ConnectToServer(UIConnectionInfo connectionInfo, IDbConnection liveConnection, Boolean validateConnection)

NeM

I see this same issue too with the exact same error message as above. It is incredibly annoying to get this popup message inside SSMS 2008. At first, I thought this was an issue with SQL Data Compare 10 which was where I posted this issue first on that forum. Now I think this is an issue with SQL Compare 10.2.0.696. Here are my client specs:

Microsoft SQL Server Management Studio 10.0.5500.0
Microsoft Analysis Services Client Tools 10.0.5500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5456
Operating System 6.1.7601 (Windows 7 Professional 64bit SP1)

osumatt

I ended up uninstalling SQL Compare & SQL Data Compare until this is fixed.

Here are my specs

Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Analysis Services Client Tools 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 4.0.30319.269
Operating System 6.1.7601

NeM

FYI, this is their email response:

"This is a known issue. We have identified the problem and aim to release a fix next week. Week commencing 21st May 2012. We apologise for any inconvenience caused by this issue."

osumatt

Thanks for the heads up!

neil.anderson

Hi guys,

Sorry you are experiencing this problem. Can you please try the patch release of Compare here:

ftp://support.red-gate.com/patches/sql_ ... .0.777.zip

and let me know if it fixes this problem for you?

Thanks,
Neil

osumatt

That did the trick. Thanks!

NeM

Yes, the patch fixed my issue too. Thanks Neil.

tbrovold

The patch resolved the issue for me as well....Thanks when will the "real" patch be available?

MCTSQL

Patch also resolved my SSMS2012 crashes post-10.2 SQLCompare