About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

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.