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  General SQL Server Forums  Database Design and Application Architecture  Help with connection rejects

Author  Topic  llandru Starting Member 1 Post Posted - 2009-06-27 : 12:27:43 I have a small company which does business on the web -- our app is hosted on a VPS server with a SQL Server back end on a shared DB server. Most of the time, our traffic is not very high. However, occasionally we have an "event" in our application (it's a long story), during which several hundred users must log on and perform a task. When this happens, we see quite a few of the following errors: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings..... I have worked to fine-tune the queries taking place in the pages that our users are accessing, and have also taken steps to minimize the number of connections being used by the app during this time. However, we're still not able to get through our load-testing without encountering these errors. I was hoping someone might have some suggestions -- I've been using SQL Server for a couple years now but admittedly not as an "advanced" user, nor am I an expert administrator. Thanks!