locked
ssms 17.6 and 17.5 not working. RRS feed

  • Question

  • Hi experts,

    Its extremely annoying, none of them is working... I installed 17.6 now 17.5... and when I hit 'new query' it shuts down:

    Then...

    THen...

    And if I hit debug:

    Thursday, April 19, 2018 9:20 AM

All replies

  • It seems like there is problem with .net framework. Can you uninstall both and install only SSMS 17.5 and try. Look into event viewer do you find any other message related to Visual studio or .Net framework

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Proposed as answer by Teige Gao Friday, April 20, 2018 7:34 AM
    • Unproposed as answer by maca128 Friday, April 20, 2018 10:08 AM
    Thursday, April 19, 2018 9:28 AM
  • Or use the Microsoft .NET Framework Repair Tool to fix may existing issues.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Friday, April 20, 2018 7:34 AM
    • Unproposed as answer by maca128 Friday, April 20, 2018 10:08 AM
    Thursday, April 19, 2018 9:39 AM
  • Have done so, and still fails. Any other help?
    Friday, April 20, 2018 8:35 AM
  • Found 2 erros on event viewer:

    Faulting application name: Ssms.exe, version: 2017.140.17230.0, time stamp: 0x5aa77b02
    Faulting module name: WindowsBase.ni.dll, version: 4.7.2558.0, time stamp: 0x59d41ae3
    Exception code: 0x80131623
    Fault offset: 0x002809a3
    Faulting process id: 0x3ddc
    Faulting application start time: 0x01d3d894161c96fd
    Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe
    Faulting module path: C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\WindowsBase\d9eac8ec5a604324b2ad7792cf8d8ed4\WindowsBase.ni.dll
    Report Id: 9889b185-67cd-4cb4-928f-d89b5801d2f3
    Faulting package full name:
    Faulting package-relative application ID:

    ***************

    Application: Ssms.exe
    Framework Version: v4.0.30319
    Description: The application requested process termination through System.Environment.FailFast(string message).
    Message: Unrecoverable system error.
    Stack:
       at System.Environment.FailFast(System.String)
       at MS.Internal.Invariant.FailFast(System.String, System.String)
       at System.Windows.Media.FontFamily.get_FirstFontFamily()
       at System.Windows.Controls.TextBox.GetLineHeight()
       at System.Windows.Controls.TextBox.SetScrollViewerMinMaxHeight()
       at System.Windows.Controls.TextBox.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Grid.MeasureCell(Int32, Boolean)
       at System.Windows.Controls.Grid.MeasureCellsGroup(Int32, System.Windows.Size, Boolean, Boolean, Boolean ByRef)
       at System.Windows.Controls.Grid.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Control.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Grid.MeasureCell(Int32, Boolean)
       at System.Windows.Controls.Grid.MeasureCellsGroup(Int32, System.Windows.Size, Boolean, Boolean, Boolean ByRef)
       at System.Windows.Controls.Grid.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Grid.MeasureCell(Int32, Boolean)
       at System.Windows.Controls.Grid.MeasureCellsGroup(Int32, System.Windows.Size, Boolean, Boolean, Boolean ByRef)
       at System.Windows.Controls.Grid.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Grid.MeasureCell(Int32, Boolean)
       at System.Windows.Controls.Grid.MeasureCellsGroup(Int32, System.Windows.Size, Boolean, Boolean, Boolean ByRef)
       at System.Windows.Controls.Grid.MeasureCellsGroup(Int32, System.Windows.Size, Boolean, Boolean)
       at System.Windows.Controls.Grid.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at MS.Internal.Helper.MeasureElementWithSingleChild(System.Windows.UIElement, System.Windows.Size)
       at System.Windows.Controls.ContentPresenter.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Controls.Control.MeasureOverride(System.Windows.Size)
       at System.Windows.FrameworkElement.MeasureCore(System.Windows.Size)
       at System.Windows.UIElement.Measure(System.Windows.Size)
       at System.Windows.Interop.HwndSource.SetLayoutSize()
       at System.Windows.Interop.HwndSource.set_RootVisualInternal(System.Windows.Media.Visual)
       at System.Windows.Interop.HwndSource.set_RootVisual(System.Windows.Media.Visual)
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow+TextViewShimHost.set_TextViewHost(Microsoft.VisualStudio.Text.Editor.IWpfTextViewHost)
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Init_InitializeWpfTextView()
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Init_OnActivation()
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Init_OnTextBufferInitialized(System.Object, System.EventArgs)
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Init_SetBuffer(Microsoft.VisualStudio.TextManager.Interop.IVsTextLines)
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Init_Initialize(Microsoft.VisualStudio.TextManager.Interop.IVsTextLines, IntPtr, UInt32, Microsoft.VisualStudio.TextManager.Interop.INITVIEW[])
       at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.Initialize(Microsoft.VisualStudio.TextManager.Interop.IVsTextLines, IntPtr, UInt32, Microsoft.VisualStudio.TextManager.Interop.INITVIEW[])
       at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextViewControl.CreateEditorWindow(System.Object)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TextResultsViewContol.CreateEditorWindow(System.Object)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl+TextEditorForAnalysisServicesMessages.CreateEditorWindow(System.Object)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextEditorControl.CreateAndInitEditorWindow(System.Object)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl.AllocateTextEditor(Boolean)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl.CreateAndInitMessagesEditor()
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl.System.IServiceProvider.GetService(System.Type)
       at Microsoft.AnalysisServices.Controls.QueryExecution.AnalysisServicesExecutionControl.InitializeWithServiceProvider(System.IServiceProvider)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl.OnHosted()
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.DisplayAnalysisServerResultsControl.SetSite(System.Object)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.MdxScriptEditorControl.OnHosted()
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptEditorControl.SetSite(Microsoft.VisualStudio.OLE.Interop.IServiceProvider)
       at Microsoft.VisualStudio.Platform.WindowManagement.WindowPaneDocumentObject.SetSite(Microsoft.VisualStudio.Platform.WindowManagement.DocumentObjectSite)
       at Microsoft.VisualStudio.Platform.WindowManagement.DocumentObjectSite.InitializeDocumentObject(System.Object)
       at Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.CreateContentPane(Microsoft.VisualStudio.Platform.WindowManagement.FrameMoniker, Boolean, System.String, UInt32, System.Object, System.Object, Microsoft.VisualStudio.OLE.Interop.IServiceProvider, Microsoft.VisualStudio.Shell.Interop.IVsUIHierarchy, UInt32, System.Guid, Microsoft.VisualStudio.PlatformUI.Shell.ViewGroup, Microsoft.VisualStudio.Shell.Interop.IVsWindowFrame ByRef)
       at Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.CreateContentPane(System.String, Int32, Int32, System.String, UInt32, UInt32, System.Object, System.Object, Microsoft.VisualStudio.OLE.Interop.IServiceProvider, Microsoft.VisualStudio.Shell.Interop.IVsUIHierarchy, UInt32, Int32 ByRef, System.Guid ByRef, Microsoft.VisualStudio.Shell.Interop.IVsWindowFrame ByRef)
       at Microsoft.VisualStudio.Shell.Interop.IVsProject.AddItem(UInt32, Microsoft.VisualStudio.Shell.Interop.VSADDITEMOPERATION, System.String, UInt32, System.String[], IntPtr, Microsoft.VisualStudio.Shell.Interop.VSADDRESULT[])
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateNewScript(System.String, Microsoft.VisualStudio.Shell.Interop.IVsProject, Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionGroupInfo, System.Data.IDbConnection, System.String)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateNewScript(System.String, Microsoft.VisualStudio.Shell.Interop.IVsExternalFilesManager, Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionGroupInfo, System.Data.IDbConnection, System.String)
       at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateNewBlankScript(Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptType, Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionGroupInfo, System.Data.IDbConnection)
       at Microsoft.SqlServer.Management.SqlStudio.OnNewQueryWithCurrentConnection(System.Object, System.EventArgs)
       at System.ComponentModel.Design.MenuCommand.Invoke()
       at System.ComponentModel.Design.MenuCommand.Invoke(System.Object)
       at Microsoft.VisualStudio.Shell.OleMenuCommandService.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(System.Guid ByRef, UInt32, UInt32, IntPtr, IntPtr)
       at Microsoft.SqlServer.Management.SqlPackage.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(System.Guid ByRef, UInt32, UInt32, IntPtr, IntPtr)
       at Microsoft.VisualStudio.Shell.Interop.IVsUIDataSource.Invoke(System.String, System.Object, System.Object ByRef)
       at Microsoft.Internal.VisualStudio.PlatformUI.DataSource.Invoke(System.String, System.Object, System.Object ByRef)
       at Microsoft.VisualStudio.PlatformUI.VsCommand.Execute(System.Object)
       at MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(System.Windows.Input.ICommandSource, Boolean)
       at System.Windows.Controls.Primitives.ButtonBase.OnClick()
       at System.Windows.Controls.Button.OnClick()
       at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(System.Windows.Input.MouseButtonEventArgs)
       at System.Windows.UIElement.OnMouseLeftButtonUpThunk(System.Object, System.Windows.Input.MouseButtonEventArgs)
       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(System.Delegate, System.Object)
       at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
       at System.Windows.UIElement.ReRaiseEventAs(System.Windows.DependencyObject, System.Windows.RoutedEventArgs, System.Windows.RoutedEvent)
       at System.Windows.UIElement.OnMouseUpThunk(System.Object, System.Windows.Input.MouseButtonEventArgs)
       at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(System.Delegate, System.Object)
       at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
       at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
       at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
       at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
       at System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs)
       at System.Windows.Input.InputManager.ProcessStagingArea()
       at System.Windows.Input.InputManager.ProcessInput(System.Windows.Input.InputEventArgs)
       at System.Windows.Input.InputProviderSite.ReportInput(System.Windows.Input.InputReport)
       at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr, System.Windows.Input.InputMode, Int32, System.Windows.Input.RawMouseActions, Int32, Int32, Int32)
       at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr, MS.Internal.Interop.WindowMessage, IntPtr, IntPtr, Boolean ByRef)
       at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
       at MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
       at MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)
       at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
       at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
       at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
       at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)

    Friday, April 20, 2018 12:21 PM