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"

    Relevant Pages

    • Re: Special Crosstab
      ... Your SQL in the Concatenate function might need to look something like: ... This worked GREAT when I changed my Account Numbers ... >>> Dim rst As DAO.Recordset ... >>> Dim strText As String ...
      (microsoft.public.access.queries)
    • Re: Transformation problem
      ... I also had to change the field size for account, ... string and dumps it into a text file. ... run the query in sql it works fine. ... When I click on the transformations tab I get an error ...
      (microsoft.public.sqlserver.dts)
    • Re: Special Crosstab
      ... >Your SQL in the Concatenate function might need to look ... This worked GREAT when I changed my Account ...
      (microsoft.public.access.queries)
    • Re: Problems with Delete Command
      ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Need help with Code Please!!!
      ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
      (microsoft.public.access.formscoding)