error message not being logged to windows event log

Hi,
I am trying to get a message (#18453 - Login succeeded for use '%ls%'. Conn
ection: Trusted) to the windows event log. It's severity is 14 and it is al
ready checked off as a logged event, but it is not being logged. Is this a
bug or is there something e
lse I need to configure?
Regards
AThe login messages are (for some reason) handles differently from the other
messages. EM, right-click your server, properties, Security tab.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:4669ADC2-F0E4-48B5-BC66-77F95B76CEBE@.microsoft.com...
> Hi,
> I am trying to get a message (#18453 - Login succeeded for use '%ls%'.
Connection: Trusted) to the windows event log. It's severity is 14 and it
is already checked off as a logged event, but it is not being logged. Is
this a bug or is there something else I need to configure?
> Regards
> A
>|||Tibor,
I don't quite understand what you're saying. I have located the error messa
ge by right clicking on the server, choosing Manage SQL Server Messages, the
n to the Edit Message window, and the option to Always write to Windows even
tlog is checked on. But st
ill, it is not being recorded in the event log when I log on through Query A
nalyzer for example.
Regards,
A|||Tibor is saying that there is a different mechanism to have logins logged to
the eventlog. Checking the box in Manage SQL Server Messages does NOT work.
You have to use Enterprise Manager, right click your server, choose
Properties, and then go to the Securities Tab. There you will see a radio
button under Audit Level; you can choose one of the following:
None
Success
Failure
All
If you choose "Success" you will get a message in the Eventlog for every
successful login.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:7224910B-6005-43B3-9B18-019809B4697F@.microsoft.com...
> Tibor,
> I don't quite understand what you're saying. I have located the error
message by right clicking on the server, choosing Manage SQL Server
Messages, then to the Edit Message window, and the option to Always write to
Windows eventlog is checked on. But still, it is not being recorded in the
event log when I log on through Query Analyzer for example.
> Regards,
> A
>|||Thank you Kalen. It's now working.