SQL Server: the login is from untrusted domain and cannot be used with integrated authentication. SSMS

Question

I have two SQL Servers on different domains. I am trying to connect to SQL server "A" using SSMS on domain "B", but getting this error. Login failed. The login is from an untrusted domain and cannot be used with integrated authentication. (Microsoft SQL Server, Error 18452). Please help.

Answer 1

Given that you state the servers are in different domains ... the first comment from @squillman gives the answer. You must do one of the following:

1. establish a domain trust between the domains
2. Create an identical local (non-domain) user on each server, and use that in your connectionstring per @Charlieface, this won't work.
3. switch to a SQL login rather than using a Windows account