[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL 2005 Login Auditing

Posted on 2011-03-17
3
Medium Priority
?
371 Views
Last Modified: 2012-08-13
Experts,

I have an account that randomly gets a "login failed for user" error on my SQL server. It's an service account that runs part of the company intranet. The intranet has unfortunately been developed by a vendor who has no idea where the failed request is coming from, so I'm trying to do as much leg work as i can on the SQL side. the error seems to come randomly, so I don't want to turn SQL profiler on and monitor this all day. Is there an easier way to track down where this is coming from? The  server is already set up to log failed logins only, but I don't know where these are logged, nor do I know if there's more i can do to capture more information.

Thanks in advance for the help.

0
Comment
Question by:Butterfield_Cayman
3 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 500 total points
ID: 35162631
If Audit failed login is enabled, you can check the SQL Server Error Logs, It will have an entry for failed logins with the CLIENT.
0
 
LVL 2

Assisted Solution

by:EL_Barbado
EL_Barbado earned 500 total points
ID: 35162777
In Object Explorer  of SQL Server Management Studio, expand the "Management" > "SQL Server Logs" server you are interested in. Then Right-click > View SQL Server Log. You should be able to find more information there.
0
 

Author Closing Comment

by:Butterfield_Cayman
ID: 35165184
cheers fellas
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

612 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