Solved

login info in sql error log

Posted on 2011-03-01
6
400 Views
Last Modified: 2012-05-11
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
Comment
Question by:anushahanna
  • 3
  • 2
6 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 167 total points
ID: 35010553
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
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 333 total points
ID: 35011677
0
 
LVL 6

Author Comment

by:anushahanna
ID: 35015714
>>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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 6

Author Comment

by:anushahanna
ID: 35015720
lcohan, helpful with parameters -thank you.
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 333 total points
ID: 35018107
[
>>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
 
LVL 6

Author Comment

by:anushahanna
ID: 35030254
very fine - thanks!
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now