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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

621 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