Re: how to apply security to iis to sql

anonymous_at_discussions.microsoft.com
Date: 10/24/03

  • Next message: Ian: "virus/trojan log analysis" 
    Date: Fri, 24 Oct 2003 02:20:39 -0700

    >-----Original Message-----
    >On Thu, 23 Oct 2003 07:45:03 -0700, "paul bearne"
    ><anonymous@discussions.microsoft.com> wrote:
    >
    >>What is the recomended way to conect to a sql db from
    >>webserver
    >>
    >>iis 2000 to sql 2000 in mixed mode
    >>
    >>I am looking for a technet etc. artical showning users /
    >>password for direct and via com+
    >>
    >>i.e. do I just grant I_USSER rights to all the db's I
    need
    >>to access!
    >>
    >>If so how do I prodect the db's etc.
    >
    >A lot of this depends on how you'll be accessing the
    database, but you
    >normally would create a SQL user account with the proper
    access for
    >the database in question, then reference that user and
    password in
    >your connection string. If you're authenticating users
    you could use
    >mixed mode, and provide access based on login
    information. You would
    >never want to grant the IUSR account access to the
    database.
    >
    >Jeff
    >.
    >

    ok
    lets use a conection string can i pass a nt id in the
    string
    or does it have to be the "connect as" account for the
    folder

  • Next message: Ian: "virus/trojan log analysis"
    • Quantcast