Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SMSS 17.5 application error + crash when using Central Management Server

* Use SMSS 17.5
* Connect to an Azure SQL server instance. Use SQL Server authentication and check the "Remember password" checkbox", other options can be left at their default values.
* Under "Registered Servers" right-click "Central Management Servers" and select "Register Central Management Server..."
* In the "New server registration" dialog, in the "Server name" dropdown, select the Azure SQL server connection that was saved earlier (which should populate all the required fields), and click "Save"
* Now expand the tree node that was just created under "Central Management Servers".

>>> An error popup message appears showing "Data is null. This method or property cannot be called on Null values. (System.Data)"

From this moment, even trying to delete the node will cause the same error message, and right-clicking causes SMSS to crash.

The full stacktrace of the application crash is visible in Event Viewer:

Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Data.SqlTypes.SqlNullValueException
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32)
at Microsoft.SqlServer.Management.Common.ServerComparer..ctor(Microsoft.SqlServer.Management.Common.ServerConnection, System.String)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.get_ServerGroups()
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.get_DatabaseEngineServerGroup()
at Microsoft.SqlServer.Management.RegisteredServers.SharedServer.GetServerGroupByType(Microsoft.SqlServer.Management.Common.ServerType)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.OnSharedServerDropped(System.String)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerControl.RemoveCentralManagementServer(Microsoft.SqlServer.Management.RegisteredServers.SharedServer, Boolean)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.ResetSharedServer(Microsoft.SqlServer.Management.RegisteredServers.SharedServer, Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.Refresh(System.Windows.Forms.TreeNode)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.Refresh(System.Windows.Forms.TreeNode)
at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerTree.RegisteredServerTree_KeyUp(System.Object, System.Windows.Forms.KeyEventArgs)
at System.Windows.Forms.Control.OnKeyUp(System.Windows.Forms.KeyEventArgs)
at System.Windows.Forms.TreeView.OnKeyUp(System.Windows.Forms.KeyEventArgs)
at System.Windows.Forms.Control.ProcessKeyEventArgs(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control.ProcessKeyMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control.WmKeyChar(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.TreeView.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)

1 vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Sebastian Groeneveld shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base