Trouble Connecting to SQL Server

• Feneta Alicia

  SSC Journeyman

  Points: 97

  More actions

  October 31, 2016 at 9:55 pm

  #318493

  Hi

  I\'ve been through the set up guide for SQL Server connections but my SQL Server is reporting the following errors continuously and Logic Monitor is retrieving no data.

  01/10/2012 15:52:24,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 194.83.78.12]

  01/10/2012 15:52:24,Logon,Unknown,Error: 18452, Severity: 14, State: 1.

  01/10/2012 15:52:24,Logon,Unknown,SSPI handshake failed with error code 0x80090308, 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. [CLIENT: 194.83.78.12].

  01/10/2012 15:52:24,Logon,Unknown,Error: 17806, Severity: 20, State: 14.

  The user accounts are all able to connect directly to the SQL Server instances. I use account in ASPHostPortal.com

  Can you point me in the right direction please?

  Thanks

• HanShi

  SSC-Dedicated

  Points: 33512

  More actions

  November 1, 2016 at 2:15 am

  #1909793

  Resolve the name of the client machine [CLIENT: 194.83.78.12] -- use "ping -a 194.83.78.12" on a command prompt -- and look on that machine for any processes/jobs/applications that connect to the SQL server. Look at the account name this process/job/application is running under. Grant the account permission in SQL Server or stop the activity if it is not allowed to connect to SQL Server.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **