locked
Restrict Simultaneous Connections RRS feed

  • Question

  • I've been looking for a way to restrict a user to 2 or fewer simultaneous connections. I cannot find anything and my googling and searching through docs has been fruitless. Is this possible in SQL Server 2005?

    Chris
    Thursday, August 7, 2008 11:44 PM

Answers

  • In SQL Server 2005 you can use a LOGON TRIGGER to accomplish this task. Actually the sample given in BOL is close to what you are looking for, it should be easy to modify that sample for general purposes.

     

      BOL links:

    http://msdn.microsoft.com/en-us/library/bb326598.aspx

    http://msdn.microsoft.com/en-us/library/ms189799.aspx

     

      I hope this helps,

    -Raul Garcia

      SDE/T

      SQL Server Engine

    Friday, August 8, 2008 5:53 PM