May 4, 2016 at 9:15 am
Hello,
we have a very strange problem!!
Server Windows 2012. Installed 4 instance, SQL2008, 2008r2, 2012 and 2014. Same problem on every instance, with every SSMS version.
In rdp on the server, login with SQL User is impossibile, password digitation is lagging (2/3 seconds between every key i press!) and even if password is correct i can't login (as password is wrong).
With Windows Authentication, everything work
From another pc, everything work, windows authentication AND sql auth!!
Only the user who INSTALL SQL, can login from local with sql user!!!
We can't understand..... Some tricks??
I'm not a fool, i found only this article about this, so i'm not alone, but with no response...
Thank you
Paolo
May 5, 2016 at 7:49 am
More info!
From that server (always in rdp), i can't login using sql credential with ANY OTHER SQL Server in our network: same thing, 2/3 sec. delay when i type any character into password box and no hope to login. With windows authentication, everything is ok.
I think it's something about installation of SQL Server on Windows server 2012, some security policy of Windows, just like the char i type in password box (slowly) does not "go" to sql login in right mode, i don't know. Note a bug specific of SQL Server.
OK i can login with windows auth, but i want to resolve the problem...
Help! 🙂
Thanks to all
Paolo
May 31, 2016 at 9:10 am
Hi all,
someone else in a forum give me a solution, and it work!
Hi Paolo
I have fix this problem in my environment, go to regedit and add this:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb]
"ProtectionPolicy"=dword:00000001
You may have to reboot your server
Please give me your feedback, thanks
December 7, 2016 at 11:11 pm
Yes, I can confirm that this solution works! Thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply