[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

SQL 2005 Login Auditing

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
Butterfield_Cayman
Asked:
Butterfield_Cayman
2 Solutions
 
AnujCommented:
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
 
EL_BarbadoCommented:
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
 
Butterfield_CaymanAuthor Commented:
cheers fellas
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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