Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Trouble Connecting to SQL Server

debywilliams's profile image debywilliams posted 6 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 6 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.