Web Server and Application Servers SQL

[Brian]

I trying to figure the best solution with this. I am
looking to create a web server that will give access to a
APP(SQL) server. My question is about security. Is there
a way to have the user authenticate to the web server.
Then the web server goes to the sql server and gets the
data needed for the user. Like a reverse proxy
basically. This way the user never physcially hits the
APP server. I have read some information on a product
called IChain that does this by Novell. Is there a way to
do this with Windows 2000 or a similar Microsoft product?

Thank you.
Brian

 

[Jeff Cochran]

I trying to figure the best solution with this. I am
looking to create a web server that will give access to a
APP(SQL) server. My question is about security. Is there
a way to have the user authenticate to the web server.
Then the web server goes to the sql server and gets the
data needed for the user. Like a reverse proxy
basically. This way the user never physcially hits the
APP server. I have read some information on a product
called IChain that does this by Novell. Is there a way to
do this with Windows 2000 or a similar Microsoft product?

Using SQL, look into application roles on your SQL server.

Jeff