question

Mehdi593 avatar image
Mehdi593 asked

Limit Number Login

How to lock a SQL login after N unsuccessful login attempts
login
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
If you open the properties for a SQL-login and check the "Enforce password policy" checkbox, SQL Server will adhere to the Windows password- and lockout policy. Then you set a local (or domain) password- and lockout policy which you want SQL Server to use.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mehdi593 avatar image Mehdi593 commented ·
Thanks ! I know this Solution But domain admin don't it, how to do it by logon trigger.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.