Windows Auth login failed all of sudden

• krishnaroopa

  SSChasing Mays

  Points: 650

  More actions

  March 12, 2015 at 1:06 am

  #315644

  Hi all

  We have a SQL 2012 server, inside a domain and we have windows users in the domain accessing the server.

  All was working fine, till past week.. Now all of a sudden, the users cannot login.

  The error message is

  "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)"

  The event log shows:

  SSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. No authority could be contacted for authentication. [CLIENT: 115.242.248.246]

  I tried to delete the user and re-create the login. Was not successful.

  Windows NT user or group 'Domain\user' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

  But in the login screen, when i search for user, i get the user.

  Don't know what to do.. Please help out.

  P.S: No changes done in either side. The systems changed time during the daylight savings..

  Will this effect.

  Thanks.

  KRS