map IUSR to specific sql roles

[Hernán Castelo]

hi
i need to connect to sql
with different roles

is there any way
for do that without
passing users or passwords
in the connection string ??

 

[Ray at]

You can specify a different user account than IUSR and you can do this on a
page-by-page basis, if you'd really like to. Then if you uses integrated
security for your SQL connection, that user account will be the one that
connects. It sounds like this would be a PITA the manage though.

Ray at work