Creating IIS Login to SQL Server in multi-tier app

Discussion in 'ASP .Net Web Services' started by Ross, Nov 6, 2004.

  1. Ross

    Ross Guest

    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
    Ross, Nov 6, 2004
    #1
    1. Advertising

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


    "Ross" <> wrote in message
    news:...
    > 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
    Dino Chiesa [Microsoft], Nov 8, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. rob

    ASP v2 & 3-tier or 2-tier

    rob, Aug 13, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    404
    Steve C. Orr [MVP, MCSD]
    Aug 13, 2004
  2. NOSPAM

    2 tier to 3 tier?

    NOSPAM, Oct 14, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    425
    =?Utf-8?B?Q293Ym95IChHcmVnb3J5IEEuIEJlYW1lcikgLSBN
    Oct 14, 2004
  3. Steve Kershaw

    Setting up a new tier in a 3-tier system?

    Steve Kershaw, Mar 28, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    443
    Steve Kershaw
    Mar 29, 2006
  4. Shantanu Bhattacharya
    Replies:
    2
    Views:
    546
    Christopher Benson-Manica
    Dec 26, 2003
  5. Jeff
    Replies:
    19
    Views:
    576
    Kathryn Van Stone
    Sep 5, 2007
Loading...

Share This Page