Re: SQL Login audit log

Oscar,
Thanks for responding. I selected all, then I relogin, in the event log
viewer, I cannot find new login. Where should I read the log?

Thanks

kai
"Oscar Santiesteban Jr." <oscarsantiesteban@xxxxxxxxxxxxxxxx> wrote in
message news:JWgDe.14190$5N3.7915@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Are you trying to log all SUCESSFULL logons and FAILED logons?
> You can right-click the server in ENTERPRISE MANAGER and check the options
> for each.
>
>
> "kai" <kailiang@xxxxxxxxxxxxx> wrote in message
> news:crgDe.1579$6f.1305@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Hi, All
>> I use SQL Server 2000 and Win 2003 Server. I try to create a SQL Server
>> Login audit log using Profiler, but cannot find the tools. I looked at
>> the
>> Windows Event Viewer, it only logs Windows authentications users for SQL
>> Server not SQL Server users (Mixed mode users).
>>
>> Please help on creating SQL Server Login log (username,password and
>> time).
>>
>> Thanks
>>
>> Kai
>>
>>
>
>


.

Relevant Pages

  • 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)
  • Re: Authentication problem continued
    ... application pool? ... Login failures are logged to the Application event log therefore try to ... SQL Server is configured for Windows Authentication only and not mixed ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... Associated with this is event id 17055 from MSSQLSERVER w/description 18456: Login failed for user NT ... These messages occur in bursts of of over 100 messages every 5 minutes and just flood the application event log w/entries I think what's going on is the Alert Engine is a service running under local system and is unable to connect to SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
Loading