SQL Connection in detail

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
 
P

Patrice

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Severed connections in SQL Server Connection Pool 1
Why doesn't ADO.Net reuse the connections in the connection pool 2
problem adding connection in vs 2005 sql 2005 express 2
weird sql connection issue 2
troubles with dns-less connection to sql 0
SQL Migration - Varchar 8000 in SQL 2005 1
command timeout - SQL 2005 express - critical customer down 4
Using Widows Authentication and accesssing SQL with SQL Authentication 4

Top