SQL exception error

  • We have a job running multiple times a day from a app server which points towards the database server. The job runs fine most of the time but fails once or twice a day and gives the following error:

     

    Exception : System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ---> System.ComponentModel.Win32Exception (0x80004005): An existing connection was forcibly closed by the remote host

    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

     

    Do you know what this error means?

  • I have seen similar messages caused by intermittent network errors.

    You could try speaking to your systems people but these sorts of errors can be difficult to tie down. It is probably best to check for this exception and try again only reporting the error if it fails, for say, three times.

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

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