I was able to break SSMS and cause the behaviour you're seeing but only by altering the HKEY_CLASSES_ROOT\ssms.sql.14.0\Shell\Open\DdeExec registry key. I couldn't trigger this by changing the OpenWith preference in...

Are you seeing any errors in Replication?

USE [distribution]
GO
SELECT [time],[error_text]
FROM MSrepl_errors
WHERE CAST([error_text] AS VARCHAR(MAX)) <> '' AND [error_text] IS NOT NULL
ORDER BY [time] DESC

• This reply was modified 5 years, 8 months ago by  HandyD.
• This reply was modified 5 years, 4 months ago by  Dave Convery.

Do you have any entries like this:

HKEY_CLASSES_ROOT\ssms.sql.**.*

with the * being a version number? If so, what do you see under these keys:

HKEY_CLASSES_ROOT\ssms.sql.14.0\Shell\Open\Command
HKEY_CLASSES_ROOT\ssms.sql.14.0\Shell\Open\DdeExec

So DTC is part of windows operating system right? Distributed transaction has nothing to do with SQL Server right?
What version of SQL Server did you configure Always on Availability...

That error means the user doesn't have a corresponding login in SQL Server. If you log in to the SQL Server as an administrator and run the below command, does...

Integrated Authentication does not work like this in SQL Server. You cannot pass a Windows login and password in the connection string to authenticate in SQL Server.

Integrated Authentication...

You need to extract more information on the login failures. SQL Server records a severity and state for every error in SQL, and with login failures this is key to...

Do you have read only routing configured for your AG? You need to have a secondary replica configured for read-intent access, and ideally have your routing urls and routing list...

Depending on your version and edition of SQL Server, you can have up to 8 AlwaysOn Availability Replicas (up to 3 synchronous), and between 1 and N databases in each...