Trouble Connecting to SQL Server

[expired user #8962]'s profile image [expired user #8962] posted 8 years ago in Running SQL scripts Permalink

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

ansgar's profile image ansgar posted 8 years ago Permalink

Looks like you should not use Windows authentication there:

The login is from an untrusted domain and cannot be used with Windows authentication.

Uncheck this option in the session manager, and set username + password by hand.

Please login to leave a reply, or register at first.