SQL 2000 Lockout?
Hello, would anyone know if there's a way to lockout mainly a SQL (or
Windows) login for SQL Server 2000? Was wondering if there was like a
stored procedure out there that could be added to the Master db running as a
system process that checks for like 3 failed login attempts or something
along those lines.
Thanks in advance.
.
Relevant Pages
- Re: login 101..
... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ... (microsoft.public.sqlserver.security) - RE: How to create a trusted connection
... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ... (microsoft.public.sqlserver.security) - Re: Windows NT user or group not found.
... out what SQL Server thinks the login name is vs. what Windows thinks the ... When the SQL Server collation and the Windows collation are different, ... The following example uses the Param2 parameter to get the SID from Windows ... (microsoft.public.sqlserver.connect) - RE: How to create a trusted connection
... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ... (microsoft.public.sqlserver.security) - Re: Connecting to SQL from a Windows Service
... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds. ... You can try turning on login auditing in SQL Server and then check the ... (microsoft.public.sqlserver.connect) |
|