We solved this by disabling Windows Defender Credential Guard
We are seeing an issue with SQL Linked Servers and Windows 11. Kerberos doesn't seem to be passing credentials
All of our existing Windows 10 computers work fine, but the newer Windows 11 computers throw the anonymous error on the linked server. Kerberos is configured correctly along with SPN's. We can't seem to figure out why Windows 11 can't do a double hop using Kerberos.
3 answers
Sort by: Most helpful
-
-
Nick B 361 Reputation points
2023-07-12T00:07:19.23+00:00 Go to group policy and select LDAP for signing none in security settings then try go around RPC to authenticate everything and finally kerberos armoring check in group policy with KDC. Try disabling group policy computer configuration and user configuration and restart computer to try again. Check component connection.
-
AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
2023-07-12T02:24:11.9733333+00:00 Welcome to Microsoft Q&A!
Please refer to the links below:
https://www.sqlshack.com/how-to-link-two-sql-server-instances-with-kerberos/
Hope these would bring your attention to some points you hadn't noticed before.
To be honest, since we can’t check the status of your server in the forum, this type of issue is usually difficult to resolve. I suggest you consider using the phone support service provided by Microsoft which can usually help you resolve your issue.
https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
https://support.microsoft.com/en-us/supportforbusiness/productselectionBest regards,
Aniya