Pages

Thursday, May 29, 2014

Login failed for user:The user is not associated with a trusted SQL server connection.



Login failed for user:The user is not associated with a trusted SQL server connection.

I had received the following error message "ERROR “Unknown SQL Exception 18452 occured. Additional error information from SQL Server is included below. Login failed.
Login failed for user:The user is not associated with a trusted SQL server connection in Event Viewer when sharepoint server trying to connect SQL server.

        
Cause:
           This issue because of connectivity credentials has changed.

Fix/Solution/Workaround:

The whole day I am searching and fixing the issues, please do any steps



   1.     Kindly Check the accounts used by the Central Admin application pool
in the  IIS setting, and then check the accounts used by the various SharePoint services (in MMC). They are Windows SharePoint Serivces Administration, Windows SharePoint Serivces Search, and Windows SharePoint Serivces Timer.
   2.     check the time zone and date and time between AD and SQL server, if any changes, please correct it and restart the client machine
   3.     Still if you face the issue, run the following command on client machine
   4.     gpudpate /force
   5.     gpupdate /sync

   6.     Still if you face the issue, rejoin the SQL machine in th domain(in my case, i have rejoin the domain)

    7.     I fixed and got resolution based on first step 1




No comments:

Post a Comment