Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  multithread and sqlconnection problem

Author  Topic  ahmeday Starting Member 1 Post Posted - 2008-09-11 : 04:04:33 Hello, we developed a windows application in visual c# using sql server 2005 standart edition. This application is multi-threaded. There are threads that transmits data packages to database. After some time, we got an error. We wrote this error to the log: "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.116]" 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?