angadai
Reputation: 1
SQL Server: the login is from untrusted domain and cannot be used with integrated authentication. SSMS
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.
Upvotes: 0
Views: 17782
Answers (1)
Ross Presser
Reputation: 6255
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:
- establish a domain trust between the domains
Create an identical local (non-domain) user on each server, and use that in your connectionstringper @Charlieface, this won't work.- switch to a SQL login rather than using a Windows account
Upvotes: 0
Related Questions
- Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"
- Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
- SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
- Error: Login failed. The login is from an untrusted domain and cannot be usedwith Windows authentication
- Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication Access vba
- SQL login failed because due to untrusted domain
- Microsoft SQL Server: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
- Windows authetication issues"The login is from an untrusted domain and cannot be used with Windows authentication."
- SQL Server 2008 - Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
- The login is from an untrusted domain and cannot be used with Windows Authentication