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.