?
Solved

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

Posted on 2003-02-24
2
Medium Priority
?
473 Views
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.

/Steven
0
Comment
Question by:airwalk
[X]
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
2 Comments
 

Author Comment

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;320728

It solved the problem right away.

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

Accepted Solution

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

Computer101
E-E Admin
0

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