Ms SQL dis-connectivity

Netsol-NOS
Netsol-NOS used Ask the Experts™
on
Dear EE,

I have found warning at DB server when user has reported Application dis-connectivity.
 
1)  User reported Application Dis-connectivity Error as attached.
SQL Error

2) We investigate the issue and look in to the Event logs and found below WARNING. Event Id : 4227

TCP/IP failed to establish an outgoing connection because the selected local endpoint was recently used to connect to the same remote endpoint. This error typically occurs when outgoing connections are opened and closed at a high rate, causing all available local ports to be used and forcing TCP/IP to reuse a local port for an outgoing connection. To minimize the risk of data corruption, the TCP/IP standard requires a minimum time period to elapse between successive connections from a given local endpoint to a given remote endpoint.


Please confirm will user application error is due to this above error.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Developer
Commented:
According to the error message: Trace the port usage of the application(s) on that machine.

But this is normally a network layer error. The most common reason is using TCP chimney, which was introduced 2003 with SNP (Scalable Network Pack).

See also "General Network error", "Communication link failure", or "A transport-level error" message when an application connects to SQL Server.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial