How can we help you today? How can we help you today?

SQL Prompt 8.0.1.1383 crashes with SSMS2016

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
nightwind
0

Comments

23 comments

Sort by
  • Anu D
    Hi nightwind,

    I have logged a support ticket for you and will email you shortly!
    Anu D
    0
  • 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
    InvincibleR
    0
  • 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)

    b4ndt
    0
  • KCM
    Hi, I get the same error.
    Did anyone manage to resolve this?
    KCM
    0
  • nightwind
    not yet. still waiting for reply from support team.
    nightwind
    0
  • 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.
    Anu D
    0
  • 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
    KCM
    0
  • Anu D
    Hi KCM,

    Our development team is looking into this issue. I will update this thread as soon as I have an update.
    Anu D
    0
  • 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.
    tung858
    0
  • S Saunders
    I'm having the same issue in SSMS v17.1
    S Saunders
    0
  • maddoc
    Since upgrading to v8 getting the following error in ssms2016 and 2017:
    6ngbx0h29pow.png


    After clicking ok ssms2017 crashes.
    maddoc
    0
  • 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
    0
  • 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
    0
  • Myanmar
    7boy3cb2ijv9.gif

    Myanmar
    0
  • 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 :)
    Anu D
    0
  • S Saunders
    Looks like that's worked, cheers :smiley:
    S Saunders
    0
  • 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! :smile:
    Myanmar
    0
  • 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?
    taiwoa
    0
  • 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?
    Anu D
    0
  • maddoc
    Uninstalling SQL Search and installing the new version - solved the problem for me.
    Thanks.
    maddoc
    0
  • wschillo
    8.0.2.1508 still having the same problem.
    wschillo
    0
  • wschillo
    Same here!
    wschillo
    0
  • 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!
    Anu D
    0

Add comment

Please sign in to leave a comment.