About Me

My photo
I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.

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