User login - how to control number of simultaneous connections

[Mauricio Ikegami]

Hi everyone!

Is it possible to control the number of simultaneous connections one login id can have?
I`d like to avoid my users to share their login ids and passwords to help them enter data into the system.

Thanks,
Mauricio

[Chuck Lucking]

Hello Mauricio,

I don`t know of any way to limit the number of connections per user. But if I understand your question, you want to eliminate your users logging on with anothers userid and password.
One solution is if they all participate in a NT domain, your could set SQL security to Integrated. Then when they log into SQL it is mapped to their NT login. This makes it impossible to have the above situation. Keep in mind that if a user was to access SQL from somebody elses workstation it will log them in as that user currently logged into NT (providing they have been granted sql access)
If this is a possible solution, please refer to SQL books online on how to set up INTEGRATED SECURITY.

Good Luck

Chuck


On 7/30/98 8:52:43 AM, Mauricio Ikegami wrote:
> Hi everyone!

Is it possible to control the number of simultaneous
> connections one login id can have?
I`d like to avoid my users to share
> their login ids and passwords to help them enter data into the
> system.

Thanks,
Mauricio

[Mauricio]

Hi Chuck,

Thanks for your help but my environment does not allow to set up SQL Server security to Integrated (some users are in a Novell Network).

Thanks again,
Mauricio

[Gary Billins]

Using SQL Executive and a stored procedure I monitor the total number of user connections once every 3 minutes and send a message to myself when the number is close to the configured limit. This technique could be modified to support your requirement using the query like:

select nt_username,count(*)
from sysprocesses
where nt_username not in (` `,`SQLExecutive`)
group by nt_username
having count(*) > 2









On 7/30/98 8:52:43 AM, Mauricio Ikegami wrote:
> Hi everyone!

Is it possible to control the number of simultaneous
> connections one login id can have?
I`d like to avoid my users to share
> their login ids and passwords to help them enter data into the
> system.

Thanks,
Mauricio

[Mauricio]

Hi Gary,

This is a good option but I would like to avoid this. I want to cancel the connection attempt instead of monitoring the system and then drop the connection.

Thanks,
Mauricio

On 7/31/98 12:19:16 PM, Gary Billins wrote:
>
Using SQL Executive and a stored procedure I monitor the total number of
> user connections once every 3 minutes and send a message to myself when the
> number is close to the configured limit. This technique could be modified
> to support your requirement using the query like:

select
> nt_username,count(*)
from sysprocesses
where nt_username not in (`
> `,`SQLExecutive`)
group by nt_username
having count(*) > 2



>






On 7/30/98 8:52:43 AM, Mauricio Ikegami wrote:
> Hi
> everyone!

Is it possible to control the number of simultaneous
>
> connections one login id can have?
I`d like to avoid my users to share
>
> their login ids and passwords to help them enter data into the
>
> system.

Thanks,
Mauricio

[Jonathan Yang]

Almost there.

Get the spid from table master.dbo.sysprocesses.
Kill the spid.

Jonathan

On 7/31/98 2:39:55 PM, Mauricio wrote:
> Hi Gary,

This is a good option but I would like to avoid this. I want to
> cancel the connection attempt instead of monitoring the system and then
> drop the connection.

Thanks,
Mauricio

On 7/31/98 12:19:16 PM, Gary
> Billins wrote:
>
Using SQL Executive and a stored procedure I monitor
> the total number of
> user connections once every 3 minutes and send a
> message to myself when the
> number is close to the configured limit.
> This technique could be modified
> to support your requirement using the
> query like:

select
> nt_username,count(*)
from sysprocesses
where
> nt_username not in (`
> `,`SQLExecutive`)
group by nt_username
having
> count(*) > 2



>






On 7/30/98 8:52:43 AM, Mauricio
> Ikegami wrote:
> Hi
> everyone!

Is it possible to control the number
> of simultaneous
>
> connections one login id can have?
I`d like to
> avoid my users to share
>
> their login ids and passwords to help them
> enter data into the
>
> system.

Thanks,
Mauricio