SQL "connectivity" issue

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  March 11, 2008 at 4:07 pm

  #128295

  We run a Java-based product on our sql 2005 server which requires JDBC (we use Microsoft's JDBC). The job we created for that product often fails the first or second time it is run but usually succeeds the third time. Here is a typical error message:

  >>>

  0 : 08S01 : com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error

  com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error at com.microsoft.sqlserver.jdbc.SQLServerExcep

  >>>

  What tools can you recommend to help me track down the source of this error. I've reviewed the server Event logs and sql logs but they are silent at the time of failure.

  TIA,

  barkingdog

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 11, 2008 at 8:33 pm

  #788363

  Here are some links. May they help.

  http://www.websina.com/bugzero/errors/sql-server-connection-error.html

  http://blogs.msdn.com/jdbcteam/archive/2007/06/18/com-microsoft-sqlserver-jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentication.aspx