Post reply

Need To Increase "User Connections"

  • November 9, 2016 at 4:21 am

    #315414

    Hi Folks,

    As part of small verification, I changed "User Connections" on one of our Servers from default (32767) to 1. But I am unable to change it back to default, as I am getting error message while connecting to SQL Server Management Studio.

    I stopped SQL Server Agent and other services, Enabled and Disabled Protocols, still I am unable to connect to SSMS to change "User Connections" and continue my work.

    Please help me to get me out from this 🙁

  • November 9, 2016 at 4:29 am

    #1911366

    Close all connections to the server and do the changes via sqlcmd, don't use SSMS

    😎

    The command is

    EXEC sp_configure 'user connections', 32767;

  • November 9, 2016 at 4:31 am

    #1911367

    Try to connect using the DAC (Dedicated Admin Connection). If that is also not possible, you'll need to stop the SQL Server service and start it from the command prompt in single-user mode (using the -m switch, see this article[/url]).

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 3 posts - 1 through 2 (of 2 total)

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