SQL Prompt 8.0.1.1383 crashes with SSMS2016

nightwind

I'm faced with the issue, when using most recent version of SQL Prompt.
While connecting to any sql server it crashes with the following erorr:

TITLE: Microsoft SQL Server Management Studio

---

Error connecting to '***'.

---

ADDITIONAL INFORMATION:

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

---

BUTTONS:

OK

---

Anu D

Hi nightwind,

I have logged a support ticket for you and will email you shortly!

InvincibleR

Hello,
I am facing the same issue since this morning. Was working fine last week. Has there been any updates on this issue?

Thank you

b4ndt

When I use SQL Server management studio, I get the same Error;

TITLE: Microsoft SQL Server Management Studio
------------------------------
Error connecting to '(local)\'.
------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------

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

Error connecting to '(local)\'.

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

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

---

Program Location:

at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#5urd(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#UXc(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.#P7i(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.#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)

KCM

Hi, I get the same error.
Did anyone manage to resolve this?

nightwind

not yet. still waiting for reply from support team.

Anu D

Hi there,

I am working on this ticket and having a hard time replicating it. Our development team is helping me with this.

We were wondering if you can uninstall SQL Prompt and reinstall again: ftp://support.red-gate.com/patches/SQLPrompt/24May2017/SQLPrompt_8.0.1.1383.zip

Does that work at all?

We are looking into your log file @nightwind and we are working on it.

KCM

Hi,

I tried uninstalling SQL Prompt and installing the provided Version, now I can run queries but I get the same error when trying to expand the database.

thanks

Anu D

Hi KCM,

Our development team is looking into this issue. I will update this thread as soon as I have an update.

tung858

Same issue with me. SQLprompt works fine with the text window but as soon as you connect to a server in Object Explorer of SSMS 2016, SQLprompt errors out with that exact same message.

S Saunders

I'm having the same issue in SSMS v17.1

maddoc

Since upgrading to v8 getting the following error in ssms2016 and 2017:



After clicking ok ssms2017 crashes.

Myanmar

Just installed the Redgate SQL Prompt 8 and getting the same problem. What a waste of my time to troubleshoot my time over this product. Redgate should test their product before releasing to general public.

Myanmar

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

Error connecting to 'SQL server name here'.

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

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

---

Program Location:

at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#5urd(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.#UXc(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.#P7i(INodeInformation #iAPb)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.#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)

Myanmar

Anu D

Hi All,

Apologies for the delay but our team was working hard to find the root cause of the issue.

We think SQL Search was causing this issue and hence released a new version of it.

Can you please try this and let us know if this solves the issue for you?

Link to SQL Search installer here!

Hope this works for you guys

S Saunders

Looks like that's worked, cheers :smiley:

Myanmar

i run the SQL Search installer from above link from Anu D (above) and re-installed Microsoft SQL Server Management Studio (Release 16.5.3). Now I don't see any problem. Thank you so much for your help!

taiwoa

I do not get any verbose information indicating that SQL Prompt is the cause of SSMS 2016 frequent crash es (as frequently as every 30 minutes when I;m actively using SSMS). However, the frequent crashes started occurring AFTER I installed SQL Prompt 8. The file at https://files.red-gate.com/message/34rrxc7OllBF5xFJ8h16pc is no longer available.

How can I better troubleshoot this issue?

Anu D

Hi taiwoa,

Thanks for your post and apologies for the issue you are having.

Does this link work for you: Download here?

Does this solve the issue for you?

maddoc

Uninstalling SQL Search and installing the new version - solved the problem for me.
Thanks.

wschillo

Same here!

wschillo

8.0.2.1508 still having the same problem.

Anu D

Hi Wayne,

Do you see the same issue with the latest version: ftp://support.red-gate.com/patches/SQLPrompt/20Jul2017/SQLPrompt_8.0.6.1890.zip?

Let me know if this helps!