Issue : You may fine below messages in error log of SQL server , this is usually not an issue with SQl but rather windows active directory permisison issue
Message :
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: ipaddress]
Scenario:
DomainA and DomainB are the 2 domains . your Sql server is in DomainB .
A group called DomainB\windows_group exists which has access to sql server database in DomainB.
the group consists of users like DomainA\user1 , DomainA\users2 , DomainB\user3 .
the user3 in the group can access sql server without any issues, however user1 and user2 gets below error messages when trying to login to sql server
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Fixing of issue :
In the Active Directory identify the computer name on which SQl server is installed
2, right click on computer name and click on security page on the pop up menu
3, Add the group DomianB\windows_group and grant read and allowed to authenticate permission for group
Message :
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: ipaddress]
Scenario:
DomainA and DomainB are the 2 domains . your Sql server is in DomainB .
A group called DomainB\windows_group exists which has access to sql server database in DomainB.
the group consists of users like DomainA\user1 , DomainA\users2 , DomainB\user3 .
the user3 in the group can access sql server without any issues, however user1 and user2 gets below error messages when trying to login to sql server
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Fixing of issue :
In the Active Directory identify the computer name on which SQl server is installed
3, Add the group DomianB\windows_group and grant read and allowed to authenticate permission for group
No comments:
Post a Comment