Search This Blog

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


Issue-Login failed:The Login is from an untrusted domain and cannot be used with Windows authentication.Error 18542

Issue Description-This Issue comes when you have different system in same domain and you want to connect with SQL Database of one system to another.
Suppose you have two system a and b in same domain and from A system you want to access the databases  of B and you get the following error as in screenshot.



Due to this  error you will get if you are working with any reports or web applications where you are connecting using Windows Authentication you will get the same above issue..

So in order to fix this Issue below is the Solution.

Solution 
We will take above case where you want to access Database of B system .
Open B system
Ctrl R
type active Directory users and computers
It will show the active directory window
Add the user of A system User --eg x user in b system
by Right clicking User
New User -- --Screenshot.

Add user Name
Give Password
check the box password never expired
OK


Now connect you will be able to connect successfully  and your reports or web applications using B databases will work as we have added the A's user in B system to make login Trusted.

No comments:

Post a Comment