Setup windows auth in SQL managed Instance

Santosh Kumar Singh 41 Reputation points
2024-01-15T14:20:37.91+00:00

I am trying to setup windows authentication in SQL managed instance and I followed below MS articles https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-trust-based-flow?view=azuresql#create-and-configure-the-azure-ad-kerberos-trusted-domain-object   after successful completion of all steps I am still getting error "Login from untrusted domain" while choosing windows auth. I tried troubleshooting steps and when I run klist I get below error    C:\WINDOWS\system32>Klist get krbtgt/kerberos.microsoftonline.com Current LogonId is 0:0xa94fe0
Error calling API LsaCallAuthenticationPackage (GetTicket substatus): 0x6fb klist failed with 0xc000018b/-1073741429: The SAM database on the Windows Server does not have a computer account for this workstation trust relationship.     Can anyone please suggest what could be possible issue here ? Any help would be highly appreciated 

Azure SQL Database
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.