Creating IIS Login to SQL Server in multi-tier app

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ross - 06 Nov 2004 06:43 GMT

Hi

I am designing a sample app that has 3 tiers - Web Browser, dotnet app & DB
server.

I believe (correct me if I am wrong) that given that each individual user
will not be connecting to SQL server directly (except maybe for DB Admin's
etc) it is desireable to create a Login for IIS to connect to the Server & a
User Login to connect to the DB in question with the appropriate permissions.

The DOTNET app will be connecting to the DB using ADO.NET

Can anybody help me with this?

Kind regards

Ross Petersen

Reply to this Message

Dino Chiesa [Microsoft] - 08 Nov 2004 17:50 GMT

yes, you should see this guide:
http://msdn.microsoft.com/library/en-us/dnnetsec/html/SecNetch12.asp

> Hi
>
[quoted text clipped - 16 lines]
>
> Ross Petersen

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...