Only allow user to logon once

[TonyF]

I've developed a VB app which connects to an SQL Server 7.0 database. I'm using SQL Server security (not NT), but I want each user name to be used only once e.g. if user1 is logged on, another user can't login at user1 also.

 

[dneufarth]

Doesn't that imply the sharing of passwords? Never a good idea.

One would think that the default action of SQL Server would be to deny multiple concurrent logins under same ID.

I'd be interested in more info on this also.


Dave

 

[foxdev]

In my doc check, I can't see how you can do this for a SQL Server login (not an NT-type login), absent some elaborate scheme involving stored procedures and grape jelly.

Robert Bradley

http://www.foxdev.com/

 

[DougP]

I think you need some Networking 101
I would not let a person log into the network more than once.
Create a separate user in User Manager for Domains.
Then create a global group and add each user that you want to allow into SQL server.
Then in SQL Server Enterprise Manager assign that group permissions as necessary.



DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.