Fragmented records of SQL Server-related knowledge and experience

1. A transport-level error occurred while sending a request to the server

A transport-level error occurred while sending a request to the server. (PROVIDER:TCP provider, error:0-the remote host forced the shutdown of an existing connection.) )---> System.Data.SqlClient.SqlException: A Transport-level error occurred while sending the request to the server.
Started to think that it was a problem with the network connection, and finally found that the database connection string .

The previous database connection string is:

"Server= server;database=database; uid= uid;p wd= pwd";
Later modified to:
"Server= server;database=database; uid= uid;p wd= pwd;pooling=false";

Add Pooling=false This setting, solve OK!
The problem is that when. NET is connected to SQL Server, resources such as a connection pool have been exhausted, or reached the maximum number of connections, so we added a sentence before the error: Sqlconnection.clearallpools ()

In the next update, please look forward to ...

Fragmented records of SQL Server-related knowledge and experience