All geek questions in one place

The connection was successfully established with the server, but then an error occurred during the confirmation / login process before entering

I am developing an SMS server that receives SMS, analyzes them and replies to messages. This application is developed with framework 4.0 and SQLServer 2008 entities.

When I receive SMS, I start a new thread for this message, as well as analyze and reply to the message. Each thread has its own new instance of the object context, and all threads invoke the same stored procedure in SQL Server.

But when a large number of SMS arrived on the server and the number of threads increased, I get one of these 2 errors every time:

Invalid base provider Open. The connection was successfully made with the server, but then an error occurred during the pre-login handshake. (Supplier: TCP provider, error: 0 - The specified network name is no longer available.)

OR

Invalid base provider Open. The connection was successfully established with the server, but then an error occurred during the login process to process. (Supplier: TCP provider, error: 0 - The specified network name is no longer available.)

I increase Max. pool size and connection timeouts up to 400 and 150. Can someone help me ?? Thanx

+3
source share
2 answers

, - . :
sp_configure 'user connections', 0 go reconfigure with override

Connections section, : Maximum number of concurrent connections 0 ().

+1

Source: https://habr.com/ru/post/1777149/

More articles:


All Articles