Results 1 to 2 of 2

Thread: user connections problem

  1. 06-06-2001, 11:17 AM #1
    aruna Guest

    user connections problem

    We are having a problem with the maximum number of user connections to sql. Currently we have a max of 500 connections and we are unable to connect to sql because the max number has been exceeded. The sql logs are flooded with repeated error messages about the user conncetions being maxed out.

    Anyone has an idea why this could be happening? Also, can it be fixed by rebooting the server?

    Thanks
    Reply With Quote Reply With Quote
  2. 06-06-2001, 12:03 PM #2
    Ray Miao Guest

    user connections problem (reply)

    Use sp_configure to increase server option 'user connections'.


    ------------
    aruna at 6/6/01 12:17:01 PM

    We are having a problem with the maximum number of user connections to sql. Currently we have a max of 500 connections and we are unable to connect to sql because the max number has been exceeded. The sql logs are flooded with repeated error messages about the user conncetions being maxed out.

    Anyone has an idea why this could be happening? Also, can it be fixed by rebooting the server?

    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules