Re: Connection Logs in SQL Server

David Williams (dw149@xxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: Performance really poor if calling data from sql clients
    ... cannot see even in the profiler. ... recommendation of using TCP instead of Named Pipes to get performance. ... what is the problem with TCP as connection type? ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server Profiler and connection.Open
    ... How I can adjust Profiler to this business? ... ADO .Net lingers on the connection for another 60 seconds, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Connection security problems with a 3 tier application
    ... As testing the connection to SQL Server, as you application will use the ... authentication or SQL Server authentication), you could use profiler to ...
    (microsoft.public.sqlserver.connect)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)