Post reply

maximum number of concurrent connections - help

  • December 27, 2010 at 4:35 am

    #244669

    Hi,

    While I was practicing with my local system, I have changed "maximum number of concurrent connections" to 1..From that time I was unable to login to my server.

    Please find error attached.

    Please help me.

    🙂

  • December 27, 2010 at 6:02 am

    #1266414

    Ram,

    Once this happend with me. What I did was based on this post as follow:

    {To use sp_configure to increase the maximum number of concurrent

    connections, follow these steps:

    1. Click Start, click Run, type cmd, and then click OK.

    2. At the command prompt, type the following command, and then press ENTER.

    sqlcmd.exe -E -S servername

    3. When you successfully connect to the instance of SQL Server 2005,

    execute the following Transact-SQL statements at the SQL Server prompt.

    sp_configure 'user connections', <NewNumber>

    Go

    Reconfigure

    Go

    4. Restart the SQL Server service for the change to take effect.

    }

    Site: http://www.ureader.com/message/2671598.aspx

    Regards,

    Rafael Melo - Brazil

  • December 27, 2010 at 6:04 am

    #1266416

    You can revert the value back to 0 (unlimited) connecting with DAC.

    Here's a MSDN page that describes how to use the Dedicated Administrator Connection. Basically, you have to connect your SSMS to "Admin:yourservername" from the server machine.

    Once you're connected, run this:

    EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

    GO

    EXEC sys.sp_configure N'user connections', N'0'

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE

    GO

    Hope this helps,

    Gianluca

    -- Gianluca Sartori

  • December 27, 2010 at 7:19 am

    #1266437

    Hi Rafael,

    I tried, But I even unable to connect query analyzer and even using sqlcmd.

    Please help. Find attached error

    🙂

  • December 27, 2010 at 9:14 am

    #1266473

    Ram:

    I did a test here and it worked. I stopped the sqlserver Agent (it was using the only one connection allowed) and then I was able to connect by SSMS.

    p.s: sorry my English.

    regards,

    Rafael Melo - BR

  • December 27, 2010 at 9:29 am

    #1266477

    Have you tried with DAC?

    -- Gianluca Sartori

  • December 27, 2010 at 10:03 am

    #1266490

    Hi Gianluca Sartori,

    Your suggestion helped me to rectify the issue..

    Thank you very much.

    Regards

    Ram..

    🙂

  • December 27, 2010 at 10:11 am

    #1266495

    You're welcome.

    Glad I could help.

    -- Gianluca Sartori

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply