SSMS Analysis Services with SQL Search

• 
  Same problem for me. Any help?

  Dietmar March 06, 2024 07:29

  - 0 +
• 
  Hello, 
  
  Can you please let me know the version of SQL Search you have installed?
  
  Best, 
  
  Hassan 
  Product Support Engineer

  hassan_imam March 06, 2024 14:34

  - 0 +
• 
  Hello,
  SQL Search 3.6.12.4244 and SSMS 18.12.1
  
  Vratislav

  Vratislav March 06, 2024 15:43

  - 0 +
• 
  Hey Vratislav, 
  
  My apologies for the oversight, Given the distinct functionalities and focus areas of SQL Search and SSAS, SQL Search is not directly applicable to SSAS. Redgate's SQL Search tool is tailored towards the relational database aspects managed through SQL Server and does not natively interact with the OLAP cubes, dimensions, and measures managed within SSAS.
  
  For tasks specific to SSAS, such as searching within cube definitions, MDX scripts, or other analysis services objects, you might need to explore other tools
  
  Best, 
  
  Hassan 
  Product Support Engineer
  

  hassan_imam March 06, 2024 15:50

  - 0 +
• 
  Ok, I understand of the scope of your product, but as I wrote, for me is annoying that it cause falling down SSMS.
  
  Vratislav

  Vratislav March 06, 2024 16:12

  - 0 +
• 
  SQL Search 3.6.12.4244 and SSMS 19.3.4.0
  

  Dietmar March 07, 2024 06:02

  - 0 +
• 
  @Dietmar do you have same behavior with the newest SSMS?

  Vratislav March 07, 2024 06:07

  - 0 +
• 
  as far as i know, 19.3.4.0 is the latest version, and i have the same problem with this version 
  

  Dietmar March 07, 2024 06:11

  - 0 +
• 
  This is a bug and needs to be addressed. I'm getting the same issue on SSMS v18.12.1 after updating to SQL Search v3.6. If I connect to Analysis Services via SSMS it crashes with this error. The response from RedGate to say the tool is only for relational databases is of no relevance, it should not prevent me connecting to SSAS via SSMS and cause SSMS to fall over.

  JonIQ March 07, 2024 15:01

  - 0 +
• 
  Apologies again for the oversight, Ill attempt a replication and get back to you with an update.
  
  Best, 
  
  Hassan 
  Product Support Engineer

  hassan_imam March 07, 2024 15:02

  - 0 +
• 
  I have uninstalled SQL Search and still appear to be getting the error. I did update the whole toolbelt suite so could possibly be related to something else? But we have multiple users so it's possible machine needs a restart.
  
  

  JonIQ March 07, 2024 15:30

  - 0 +
• 
  I managed to replicate the behavior, although I'm uncertain about the specific product causing the issue. Interestingly, I've uninstalled most of the SSMS tools, yet the error persists. I will keep you posted. 
  
  Best, 
  
  Hassan 
  Product Support Engineer

  hassan_imam March 07, 2024 15:45

  - 0 +
• 
  Could you please confirm whether you have SQL Data Generator installed? It appears to be the source of the issue.
  
  Best, 
  
  Hassan 
  Product Support Engineer
  

  hassan_imam March 07, 2024 15:54

  - 0 +
• 
  Can confirm we have Data Generator installed. We currently use this though so uninstalling not really an option. Appreciate the quick detection of this. The problematic 'RedGate.SharedSSMS.2018.dll' seems to be shared across a number of the tools and they are all the same version. Is the DLL a red herring, or does it need a patch?

  JonIQ March 07, 2024 16:06

  - 0 +
• 
  I do not have installed SQL Data Generator, I have only SQL Search tool.

  Vratislav March 07, 2024 16:20

  - 0 +
• 
  So, here is a list of recently identified problematic products. The current recommendation is to revert to versions predating these instances
  
  Updated list of affected products:
  SQL Doc 5.2.17.4123
  SQL Dependency Tracker 3.3.21.4776
  SQL Data Generator 4.5.10.4976
  SQL Data Generator 4.5.11.5037
  SQL Source Control 7.7.3+
  
  https://download.red-gate.com/checkforupdates/
  
  Vratislav & Deitmar:Can you confirm if uninstalling lets SSMS connect without issue? Also, can you show us all of the redgate products and their version you have installed. So I can promptly forward your version to our developers so they're aware that it's affecting this product as well.
  
  I will keep you posted with updates.
  
  

  hassan_imam March 07, 2024 18:00

  - 0 +
• 
  Hello @hassan_imam
  I do not have installed any of these products on my laptop.
  
  Vratislav

  Vratislav March 08, 2024 07:36

  - 0 +
• 
  Vratislav, When you uninstall SQL Search, Are you able to connect to your SSAS instance? 
  

  hassan_imam March 08, 2024 13:28

  - 0 +
• 
  Hello @hassan_imam
  I can connect to SSAS instance also with installed SQL Search, but I have to have closed SQL Search window. With opened SQL Search Windows it will fall down.
  
  
  Vratislav

  Vratislav March 11, 2024 06:43

  - 0 +
• 
  HI Vratislav, 
  
  Thank you for the info. Our development team is aware of this issue, and they are currently working on a fix expected to be available later this week. I will notify you as soon as it becomes available.
  
  Hassan 
  Product Support Engineer
  

  hassan_imam March 13, 2024 21:21

  - 0 +
• 
  We have the same issue: our info here:
  
  

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

  
  

  Error connecting to '<servername>'.

  
  

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

  
  

  Object reference not set to an instance of an object. (RedGate.SharedSSMS.2019)

  
  

  ------------------------------

  Program Location:

  
  

     at RedGate.SharedSSMS.VersionSpecific.ConnectionManager2018Plus.TryConvertConnectionPropertiesFromSqlConnectionInfo(SqlConnectionInfo connectionInfo, IConnectionProperties& connectionProperties)

     at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.ParseNodeInformationInner(INodeInformation node)

     at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.ParseNodeInformation(INodeInformation node)

     at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.SetSelectedNode(INodeInformation node)

     at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.AfterSelect(Object sender, TreeViewEventArgs e)

     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 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.ContainerControl.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 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)

  
  

  
  

  
  

  -----------------------------------------

  
  

  Version Information:

  
  

  Red-Gate Promt 10.14.8.6563

  
  

  SQL Server Management Studio 19.3.4.0

  SQL Server Management Objects (SMO) 16.200.48053.0+08fe64c9e8eb5ff3c7ea5787f145e9ecb3d57df8

  Microsoft T-SQL Parser 17.0.27.0+b6df00d03710e3fafcbe827aad08bdbe9d45d1ab

  Microsoft Analysis Services Client Tools 16.0.20054.0

  Microsoft Data Access Components (MDAC) 10.0.19041.3570

  Microsoft MSXML 3.0 6.0 

  Microsoft .NET Framework 4.0.30319.42000

  Operating System 10.0.19045
  
  
  

  PawJ March 25, 2024 12:10

  - 0 +
• 
  Any news?

  Dietmar March 28, 2024 06:44

  - 0 +
• 
  Hi all,
  
  The latest bundle installer listed below should contain the fix for this issue:
  SQL Toolbelt Essentials
  
  Let me know how it works for you.

  chrisqtran April 01, 2024 17:30

  - 0 +
• 
  works for me now

  Dietmar April 02, 2024 12:42

  - 0 +

Add comment

Please sign in to leave a comment.