SQL Connection in detail

  • Thread starter Thread starter Markus Hirsch
  • Start date Start date
M

Markus Hirsch

Hi,

I have a dotnet 2.0 application, that uses the connection pool to connect to
a sql server. That works pretty good.

Which kind of authentication is used between the application server and the
sql server when persistent connections are used?

When I use my sniffer to look into the packets, I can't see the
authentication. Is it somehow encrypted and where can I find something about
the connectionsetup from the TDS protocol point of view?

TIA
Markus
 
The one you defined ;-)

What is the connection string you are using ? If ASPNET impersonation could
also come into pay.

You could start by using the SQL Server Profiler that shows the identity
under which each statement runs...
 
Back
Top