Help! - 17302 The maximum limit for connections has been reached.

Posted on 2003-02-24
Medium Priority
Last Modified: 2012-05-04
Under advisement we had change the maximum connections to 1 in the SQL server enterprise number.

Now we cannot connect to the server even using that, so its impossible to change it back :|

Does anyone have any idea how it is possible to change the maximum connections back???

any help is deeply appreciated, I am pulling my hair out right now.

Question by:airwalk
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 8007359
We have managed to find an answer to the problem now. If anyone sees this problem the following page is very useful :


It solved the problem right away.

Is there a way to get the points back and close the question?

Accepted Solution

Computer101 earned 0 total points
ID: 8009942
Points refunded and placed in PAQ

E-E Admin

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question