Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Provider:TCP Provider, error:0 - An existing connection was forcibly closed by the remote host Expand / Collapse
Author
Message
Posted Sunday, September 23, 2012 6:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 9:23 PM
Points: 1, Visits: 6
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.
Post #1363220
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse