Results 1 to 3 of 3

Thread: user connections

  1. 11-27-2003, 03:12 PM #1
    Dany
    Dany is offline Registered User
    Join Date
    Nov 2003
    Posts
    1

    user connections

    Hi

    I want to set a maximum number of user that can simultaneously be connected to the MS SQL server.

    I used this script but that it doesn't work.

    EXEC sp_configure 'show advanced option', '1'
    RECONFIGURE
    EXEC sp_configure

    EXEC sp_configure 'user connections', '1'
    RECONFIGURE WITH OVERRIDE
    EXEC sp_configure

    Does somebody can show me how to set a maximum of user connections?

    Dany
    Reply With Quote Reply With Quote
  2. 11-28-2003, 07:10 AM #2
    Claire
    Claire is offline Registered User
    Join Date
    Mar 2003
    Location
    NJ
    Posts
    201
    EXEC sp_configure 'user connections', '0'
    RECONFIGURE WITH OVERRIDE
    EXEC sp_configure
    Reply With Quote Reply With Quote
  3. 12-01-2003, 09:20 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's your license type?
    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