SQL 2005 Max 2 User connections - need more

Posted on 2006-04-30
Last Modified: 2012-08-14
Please help! I am new to SQL.
I have a windows 2003 server with SQL 2005. All service packs and updates. I recently added VERITAS backup agent to do daily backups properly. I rebooted the PC after being up for 66 days. After the reboot I get the following message:
Could not connect because the maximum number of '2' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]

I have tried to login to SQl server management studio, but it does not let me
I have tried using the sp_configure with in Analysis services, no luck
I have tried the run command
I have tried from the CMD prompt – sp_configure is not recognized!

Any suggestions?
Thank you in advanced!
Question by:DarrylRT
    LVL 1

    Author Comment

    The answer was to disable the network cards and then open up "SQl Server Management Studio". Once I disabled the two network cards I was able to get the properties and make the connections adjustment. After rebooting the PC everything is now working. Hope this will help someone else in the future!

    Thank you,
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Great!  Now, please close the question.  Here is how :

    I answered my question myself. What do I do?

    Accepted Solution

    Closed, 500 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    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.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now