"The connection was reset" error

wajid ansari

16y14k.NET

I am getting "The connection was reset" error on my live server but its working okay on my local server. The thing is that I am having a drop down on a page, When the page is loaded drop down is filled with 2 values in it, I am able to select a value in the drop down and it is loading the content in all the other controls on the page based on the selected value of the drop down, Until here every thing seems okay. The problem erupts when I try to select a different value from the drop down, It is unable to connect to the server and showing "The connection was reset" error.
Please let me know what might have making this happen.

Thanks in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

16y ago
How to connect by TCP port
To allow connections to SQL Server by TCP port, perform the following steps.
1. Click Start | Control Panel | Network Connections
2. Right click on the network adapter that services inbound connections to SQL Server and select Properties
3. Select Advanced | Windows Firewall | Settings
4. Select Exceptions | Add Port
5. Under Name put "SQL Server" and under Port Number select 1433. Use TCP as the protocol.
6. Click OK to close out all dialogs.
If you're using anything other than standard TCP/IP to access SQL Server, you'll need to enable different ports. To allow RPC over Named Pipes instead of TCP, open port 445 in the same way that I described above.

If you find answer is right then MARK is as HelpFul

Thanks
Arshad16y ago
I might be an issue with the firewall, just check the port is open at the server.

Regards,
Arshad
wajid ansari16y ago
I have already done that and its working okay on my local machine but when I check same thing for online its giving me problem.
Crish16y ago
hi

Write live database connection string in local web.config file. And try to test is as local. you will get exact error
thanks