C
Corey J Gilson
We're having trouble getting SQL Authentication to work locally on our AWS EC2 SQL Servers (all versions). SQL Authentication DOES work when we connect using SSMS from a different server. I found this (similar-seeming) article:
Error: 0x80090345 - The requested operation cannot be completed The computer must be trusted for Delegation and the Current User Windows Server 2012
About adding a DWORD key called "ProtectionPolicy" with a value of "1" to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb". That seems to take care of the problem, but I need to explain what this does in order to push it out (to verify it's not seriously compromising security.
Can someone give me the upshot of what adding that DWORD key to that node of the registry does? Or at least guide me to a place where I can look it up? I couldn't Google it successfully.
Corey
Continue reading...
Error: 0x80090345 - The requested operation cannot be completed The computer must be trusted for Delegation and the Current User Windows Server 2012
About adding a DWORD key called "ProtectionPolicy" with a value of "1" to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297eb". That seems to take care of the problem, but I need to explain what this does in order to push it out (to verify it's not seriously compromising security.
Can someone give me the upshot of what adding that DWORD key to that node of the registry does? Or at least guide me to a place where I can look it up? I couldn't Google it successfully.
Corey
Continue reading...
