An existing connection was forcibly closed by the remote host

Question

I am getting the below error from .net application code. I am using VS2008 with MS SQLServer Express 2005.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (.Net SqlClient Data Provider)

I have read the blogs and similar queries around the earlier error which was, A connection was successfully established with the server,but then an error occurred during the login process. (provider:Shared Memory Provider, error:0 - No process is on the other end of the pipe)

Following the instruction on these blogs I have now configures the server for remote connectivity with TCP/IP and Named Pipes. The order are also like TCP/IP first and then Named Pipes.

On windows firewall I have configured exception for SQL Port to be allowed on 1433 and sqlbrowser.exe to be allowed as well.

Now I am getting the ".. existing connection was forcibly closed by the remote host. error.

Please suggest any help as I have to fix this application deployment on priority.

The connection string used is,

Solution

I can make this happen on SQL Server 2008 by trying to insert a record with a "datetime not null" column set to C#'s DateTime.MinValue using the SqlDb interface.

@TestDate0=1/1/0001

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Odd message for this case for sure!