469,573 Members | 1,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Impersonation / Kerberos

Assume: IIS 6.0 and SQL Server 2000 are running on two separate windows 2003
servers on the same LAN and windows domain using Active Directory. All
client connections using IE 6.0+ are on the domain.

True or false:

To avoid sending a username and password from the client pc to the web
server while using impersonation to make database calls from our web server
to our SQL Server, we would have to use delegation so we could leverage
kerberos.

Thanks in advance!
Mark
Nov 18 '05 #1
1 1692
If you are connecting to SQL Server using Single Windows Identity from your
web server, you dont need impersonate the logged in client (also no need of
delegation). if you are just passing username to sql server, use stored proc
parameters.

if you are connecting to sql server using the identity of logged in client,
you need impersonation enabled and also delegation using kerberos.

Av.
"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Assume: IIS 6.0 and SQL Server 2000 are running on two separate windows
2003
servers on the same LAN and windows domain using Active Directory. All
client connections using IE 6.0+ are on the domain.

True or false:

To avoid sending a username and password from the client pc to the web
server while using impersonation to make database calls from our web
server
to our SQL Server, we would have to use delegation so we could leverage
kerberos.

Thanks in advance!
Mark

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Ram P. Dash | last post: by
3 posts views Thread by Wm. Scott Miller | last post: by
2 posts views Thread by Jon L. Lovesky | last post: by
26 posts views Thread by andrew_webby at hotmail | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.