Hello all,
Is there a log of all connection attempts made to a SQL server?
The server I have is on Windows 2k.

Thanks,
David

--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu

Looks like SQL Profiler will do the job. Anybody have
experience in using it to see connection attempts?

David


David Williams <dw149 (AT) acmex (DOT) gatech.edu> wrote:
--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu

Here are a couple resources (SQL Server 2000 specific):
http://www.sqlservercentral.com/arti...profiler/1461/
http://www.microsoft.com/technet/sec.../sql2kaud.mspx

Using server side traces is a good way for production environments:
http://vyaskn.tripod.com/server_side...sql_server.htm
http://www.dbazine.com/sql/sql-articles/larsen6

This one is SQL Server 2005 specific:
http://blogs.msdn.com/sqlprogrammabi...16/703079.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

This looks great.
Thanks for the help.

David
Plamen Ratchev <Plamen (AT) sqlstudio (DOT) com> wrote:

--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu

David Williams (dw149 (AT) acmex (DOT) gatech.edu) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Good point. I'm going set up a Microsoft Network Monitor on the
connection and see what traffic ( if any ) is coming across towards the
server.

That should help me a little.

David


Erland Sommarskog <esquel (AT) sommarskog (DOT) se> wrote:

--
David Williams
Georgia Institute of Technology, Atlanta Georgia, 30332
Email: dw149 (AT) prism (DOT) gatech.edu