SQL Server 2022 error: "Property Password cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)"

Question

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

I try to add SQL Server subscriber when I create new subscriptions and I check correctly name and password of subscriber but I get this error.

Answer 1

I think SSMS 19 has a bug. I had the same issue then down graded to 18.8 and was able to finish setting up the subscriber.

Answer 2

I use SSMS version 19 and it has the same error. I fixed it by re-downloading the latest version then over-installing it. It works for me.

Link to download SSMS the latest version: Download SQL Server Management Studio (SSMS)