Our admin set up a brand new Windows 2012 R2 server with Visual Studio 2015. When I try to connect to an existing sql server 2008 database (running on a windows 2008 r2 server) from Visual Studio, using Tools -> Connect to database..., I can enter all the information, the dialog retrieves the list of databases, Test Connection works, but when I click ok I get:
The computer must be trusted for delegation and the current user account must be configured to allow delegation
Both servers are under the same domain (development) and I am local admin on both of them. My account though is on a different domain that has access to the development domain.
Any ideas on how to fix this? Are they referring to the windows 2012 server or the database server in the message?
Just as a side note, I can connect successfully from another windows 2008 r2 server using the same windows account.
Update: the connection that fails uses windows authentication.
Best Answer
According to KB3000850, this affects domain-joined Windows 8.1 computers after installing security update 2992611 or update 3000850.
I added the following value under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Cryptography\Protect\Providers\df9d8cd0-1501-11d1-8c7a-00c04fc297ebProtectionPolicy = 1 (DWORD)Now I can connect.
I found some other postings about this:
https://blog.sqlauthority.com/2017/04/01/sql-server-system-security-cryptography-cryptographicexception-error-generating-xml-document/
https://social.technet.microsoft.com/Forums/windows/en-US/47faab6b-d717-4068-bee4-c694811e0066/credential-manager-problems-error-0x80090345?forum=w8itpronetworking