Sql connection

1

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: 192.168.1.134]"

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?

2

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