Web Server and Application Servers SQL

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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?
Click to expand...

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

Jeff
 
Back
Top