Posted by Erland Sommarskog on 01/24/08 22:30

David Williams (dw149@acmex.gatech.edu) writes:
> Looks like SQL Profiler will do the job. Anybody have
> experience in using it to see connection attempts?

You can use Profiler to track login and failed login attempts. However,
if the attempt to connection fails because you cannot reach SQL Server,
Profiler will not track anyhing. Quite obviously.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Performance issue using conditional WHERE clause
• Prev in forum: Re: invalid server name error
• Thread view: Re: Connection Logs in SQL Server

[Reply to this message]