Post reply

Trouble Connecting to SQL Server

  • 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

  • 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’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply