Pages

Thursday, June 23, 2011

Login failed:The login is from an untrusted domain

I have received the following error message "ERROR “Unknown SQL Exception 18452 occured. Additional error information from SQL Server is included below. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.” in Event Viewer when sharepoint server trying to connect SQL server.

        
Cause:
           This issue because of connectivity issue between AD and SQL server.
 
Resolution:
               
1. check the time zone and date and time between AD and SQL server, if any changes, please correct it and restart the client machine
2.Still if you face the issue, run the following command on client machine
gpudpate /force
gpupdate /sync
 
3. Still if you face the issue, rejoin the SQL machine in th domain(in my case, i have rejoin the domain)