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.
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.186.12.10]"
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,