?
Solved

SQL 2005 Login Auditing

Posted on 2011-03-17
3
Medium Priority
?
366 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

762 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