SQLTeam.com | Weblogs | Forums

Sql connection

A new connection was rejected because the maximum number of connections on session ID 51 has been reached. Close an existing connection on this session and retry. [CLIENT:]"

How can this error can be fixed?

And also in multithreaded applications, is sql connection brokens possible? Is there a limit to connections that threads are running in sql server?

The only cases I've seen was because the datareader wasn't closed. When you open a datareader you should also close it properly. As you noticed, there is a limit ;-).

c# - any limit of SQL Server connection count? - Stack Overflow

Configure the user connections Server Configuration Option - SQL Server | Microsoft Docs