Typing in the password field on the SQL Management Studio Connect To Server dialogue box has a long lag of about 1 seconds per character typed

The issue was:-

• Typing in the password field on the SQL Management Studio Connect To Server dialogue box has a long lag of about 1 seconds per character typed
• Authentication fails, even though the password is entered correctly

Using SQL Authentication and using another SSMS that is installed on a different server we are able to connect to the instance.

 Resolution:-

The Issue has been fixed by adding below registry key.  

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb]

"ProtectionPolicy"=dword:00000001

Thanks for Reading. 

Rule "SQL Server Database Services feature state" failed while Add node or remove node in SQL Server.

Rule "SQL Server Database Services feature state" failed while Add node or remove node in SQL Server.
-----------------------------------------------------------------------------------------------------------

---------------------------
Rule Check Result
---------------------------
Rule "SQL Server Database Services feature state" failed.

The SQL Server Database Services feature failed when it was initially installed. The feature must be removed before the current scenario can proceed.
---------------------------
OK  
---------------------------


In order to Fix this issue:-

Go to Active node and execute as per below instruction.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.BENEDICT\ConfigurationState
Change all 4 values from 2 to 1