cancel
Showing results for 
Search instead for 
Did you mean: 

Trouble Connecting to SQL Server

famelandra
Champ in-the-making
Champ in-the-making

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

3 REPLIES 3

angelborroy
Community Manager Community Manager
Community Manager

It looks like you have not installed the SSL certificate in your Alfresco server while SQL Server is waiting for an SSL handshake.

Which is your jdbc url connection string?

Hyland Developer Evangelist

kaynezhang
World-Class Innovator
World-Class Innovator

Try to add useNTLMv2=TRUE to your jdbc url  let jdbc use NTMLv2 protocol in Windows Authentication

kaynezhang
World-Class Innovator
World-Class Innovator

Try to add useNTLMv2=TRUE to your jdbc url  let jdbc use NTMLv2 protocol in Windows Authentication