SQL Server - Login failed. The login is from an untrusted domain and cannot be used with Windows authentication I am getting below error while trying to connect SQL from remote server. Local login is working fine. Can anyone help on this. Thanks in advance.
&quot;Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.186.12.10]&quot;
My environment :
Client - already test AD/DNS domain joined
Remote SQL Server - already prod AD/DNS domain joined
I have running inside test AD/DNS server isolated environment. No relationship between test AD/DNS server and prod AD/DNS server. Test domain name : contoso.com Otherwise , PROD domain name : contoso.com
Test AD/DNS Server : 10.190.10.1
Prod AD/DNS Server : 10.150.10.1
Do I have to join prod AD/DNS client machine as well ? I mean , is there any workaround solution ?
Thanks in advance,
Last Update:
Solved my issue.
I believe the issue is the client machine's domain isn't trusted by the remote server when logging in via Windows Authentication in SSMS. You should still be able to login with your AD credentials from your local SSMS client by switching the Authentication mode from Windows Authentication to Azure Active Directory - Password.
If you run into the subsequent error &quot;The certificate chain was issued by an authority that is not trusted&quot; then you can tell SSMS to trust it manually by clicking the &quot;Options&quot; button on the Login window. Then under the &quot;Connection Properties&quot; tab, check off the &quot;Trust server certificate&quot; checkbox. Then click the &quot;Connect&quot; button.
Screenshot Example