Blog Post

SQL Server Blog
2 MIN READ

SQL Server Management Studio (SSMS) 19.0 Released!

erinstellato's avatar
erinstellato
Icon for Microsoft rankMicrosoft
Jan 26, 2023
The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!       This is the recommended release for SQL Server 2022, and it includes support for combability leve...
Snag_5761c90.png
Updated Feb 03, 2025
Version 2.0
sqlserver2022
sqltools
PatSimo's avatar
PatSimo
Copper Contributor
Jun 19, 2023

Hi Erin,

 

I just encountered a new bug with SSMS 19.1:

This when adding a new merge replication subscriber (pull subscription), after entering the subscriber sql login informations.

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

Property Password cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionSettings.ThrowIfConnectionStringIsSet(String propertyName)
at Microsoft.SqlServer.Management.Common.ConnectionSettings.set_SecurePassword(SecureString value)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.Initialize(UIConnectionInfo conninfo, SqlConnection sqlconn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection..ctor(UIConnectionInfo conninfo, SqlConnection sqlconn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.ShowDialogValidateConnection(UIConnectionInfo& connInfo, Form parent, Boolean fixedServerName)
at Microsoft.SqlServer.Management.UI.PageChooseSubscribers.AddSqlSubscriber()
at Microsoft.SqlServer.Management.UI.PageChooseSubscribers.btnAddServer_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.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.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

 

I tried SSMS 17.9.1 afterwards and this version works correctly.

 

Thanks,

Patrick