Login blocking on sql2000 2

[OldSkoolSkater]

Hello

We're running SQL 2000 sp4 and want to know if its possible to prevent users logging in using the same details?
Currently using sql authentication and wondering how each sql login can sign on only once at any one time?

Cheers

Steve - Network Coordinating in the UK

 

[Catadmin]

How are people logging in? Directly to Enterprise Manager or Query Analyzer? Or they logging in via an application?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

Oh, wait. A thought just occured to me. Switch your server authentication mode to Windows Authentication (only, not mixed mode) and map the appropriate domain accounts to SQL Server.

That will force everyone to use their own login and they won't all be able to use the same SQL login because SQL logins will be disabled.

BTW, I know of no way to force a SQL login to only accept 1 persistant connection via SQL Server. You might be able to do this via a connection object in your application, but it won't prevent people from logging into EM or QA with the SQL login.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

There is no way to force a login to only be able to be used once. You would have to write this into the software that they are using to connect.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com