Re: how to apply security to iis to sql
anonymous_at_discussions.microsoft.com
Date: 10/24/03
- Previous message: anonymous_at_discussions.microsoft.com: "RE: how to apply security to iis to sql"
- In reply to: Jeff Cochran: "Re: how to apply security to iis to sql"
- Next in thread: Dmitry Kulshitsky: "RE: how to apply security to iis to sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Previous message: anonymous_at_discussions.microsoft.com: "RE: how to apply security to iis to sql"
- In reply to: Jeff Cochran: "Re: how to apply security to iis to sql"
- Next in thread: Dmitry Kulshitsky: "RE: how to apply security to iis to sql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|