Solved

SQL 2005 Login Auditing

Posted on 2011-03-17
3
358 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 125 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 125 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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