Re: SQL alerts

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/29/04


Date: Mon, 28 Jun 2004 18:45:48 -0600

If this is just to capture who attempted the failed sa
login, that's not something you can obtain through SQL
Server with the current release. You'd have to capture this
information by using network monitor or a similar tool.

-Sue

On Mon, 28 Jun 2004 15:25:01 -0700, Brucee
<Brucee@discussions.microsoft.com> wrote:

>I am able to get an alert working for "all databases insufficient permissions" but the message does not tell me who tried to logon or from where. I get alerts from time to time for failed sa login but I cannot find out who is trying to use it from the alert.
>
>I have tried to set the above alert on each database but it will not work.
>
>Any ideas will be much appriciated
>
>Cheers Bruce



Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... the snapshot agent IS using sql login to connect to the ... The pull distribution agent IS using sql ... Do you know where SQL Server 2000 saves the sql ...
    (microsoft.public.sqlserver.replication)
  • Re: Can you update/process AS2005 cube with AMO and SQL authentica
    ... We have cases where the AS server and the Data Source server reside on 2 ... The data source is properly secured using SQL Server ... login and no serious client will accept the login with no password. ...
    (microsoft.public.sqlserver.olap)
  • Login failed for user (null). Reason: Not associated with a trus
    ... I'm running SQL 2000 on two machines, one developer edition, one standard. ... server, running windows 2000 server. ... Basicly for troubleshooting, I also have tried using the sa Login, ...
    (microsoft.public.dotnet.framework.aspnet.security)