Re: Authentication options with SS2005
- From: Jason <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 17 Sep 2007 07:32:02 -0700
Thanks for the info.
If I follow this trigger correctly, it keeps a login from having multiple
simultaneous sessions, right?
What I was looking for is a way to watch how many times a sql server login
(using sql authentication, not windows) was attempted with a bad password,
and after a set number of consecutive failed login attempts….lock out the
"Uri Dimant" wrote:
SP2 should be installed on the system
This trigger prevents from 'AuditLogin' login having more that one
Modufy this script for your needs
create login AuditLogin with password = ‘AuditLoginPswd’
/*Create a very simple login trigger */
create trigger AuditLogin_Demo
/* server means instance level*/
on all server
with execute as self
/* We specify the logon event at this stage
– If there are more than one connections,
– Issue a rollback*/
IF ORIGINAL_LOGIN()= ‘AuditLogin’ AND
(SELECT COUNT(*) FROM sys.dm_exec_sessions
WHERE is_user_process = 1 AND
original_login_name = ‘AuditLogin’) > 1
"Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
we have an issue were we need an instance of ss to lockout and account
more logins than is set by our domain policy.
as far as the hacker scenario, that could happen now using windows
"Charles Wang[MSFT]" wrote:
SQL Server does not provide such function. You may give Microsoft
via https://connect.microsoft.com/sql so that your suggestion will be
by the product team and you may get their responses via email.
Personally I do not think that this is a secure way since your valid
will face the risk of locking if some hackers just want to make your
locked. If it is required for you, you may consider implementing this
function in your application level by yourself. I think that your meaning
of locking logins here is that you temporarily DENY all the permissions
If you have any other questions or concerns, please feel free to let me
know. Have a good day!
Microsoft Online Community Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
This posting is provided "AS IS" with no warranties, and confers no
- Prev by Date: Re: how to change password with SSMS?
- Next by Date: Re: users log
- Previous by thread: Re: Authentication options with SS2005
- Next by thread: Re: Authentication options with SS2005