Ms SQL dis-connectivity

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
Netsol-NOSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
TCP/IP

From novice to tech pro — start learning today.