• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

login info in sql error log

is there a reason why sql server does not put the corresponding login in error log.? they put spid, but a spid that is weeks old - is it useful to anyone?

thanks
0
anushahanna
Asked:
anushahanna
  • 3
  • 2
3 Solutions
 
BrandonGalderisiCommented:
Well you are reviewing logs that are weeks old :D.  Is it necessary to know the login for which an error occurred?  If you are trying to track down some sort of security breach, the error log will likely not help.
0
 
lcohanDatabase AnalystCommented:
0
 
anushahannaAuthor Commented:
>>Is it necessary to know the login for which an error occurred?
at least that is more helpful than a SPID, not? :)

>>security breach, the error log will likely not help.
so what is the best bet to check something for security audit, when it was not pre-planned- what is the best we have in SServer?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
anushahannaAuthor Commented:
lcohan, helpful with parameters -thank you.
0
 
lcohanDatabase AnalystCommented:
[
>>Is it necessary to know the login for which an error occurred?
at least that is more helpful than a SPID, not? :)
]
I would use SQL profiler and in there you select hostname, loginname, error, and any other columns you want then run it filtered where error > 0. SQL Logs have different purpose.

[
>>security breach, the error log will likely not help.
so what is the best bet to check something for security audit, when it was not pre-planned- what is the best we have in SServer?
]


your OS event viewer has detailed info about any "security breach"
0
 
anushahannaAuthor Commented:
very fine - thanks!
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now