Professional Web Applications Themes

Database access using SQL 2000, ASP and IIS 5 - ASP Database

Sorry for the cross post, but after three days and no answer, I figured I'd try another board. I have ISA server logging to SQL2K which is installed on the ISA server. Our primary internal website server has a system DSN linked to the ISA SQL Server called ISALogs, which is set to the ISALogs database on the SQL Server. I made a webpage in asp that opens a DSN: conn.open sqltext, "DSN=ISALogs; uid=sa; password=passwd" This failed as did other accounts I made and tried. It appears to not matter as 'NT AUTHORITY\ANONYMOUS LOGON' seems to be the only account ...

  1. #1

    Default Database access using SQL 2000, ASP and IIS 5

    Sorry for the cross post, but after three days and no answer, I figured I'd
    try another board.

    I have ISA server logging to SQL2K which is installed on the ISA server. Our
    primary internal website server has a system DSN linked to the ISA SQL
    Server called ISALogs, which is set to the ISALogs database on the SQL
    Server.

    I made a webpage in asp that opens a DSN:

    conn.open sqltext, "DSN=ISALogs; uid=sa; password=passwd"

    This failed as did other accounts I made and tried. It appears to not matter
    as 'NT AUTHORITY\ANONYMOUS LOGON' seems to be the only account type that is
    attempting authentication on the system dsn (I don't know that for sure
    though).

    The error I get in the web browser is:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
    AUTHORITY\ANONYMOUS LOGON'.
    /testing.asp, line 29


    Line 29 is shown above (conn.open....).

    I know I could probably go into IIS properties and under Anonymous Login put
    in a domain account then give that account privleages, but I'm hoping to
    avoid this if there is another way.

    Thanks,
    Jim



    Jim Guest

  2. #2

    Default Re: Database access using SQL 2000, ASP and IIS 5

    Why are you using a DSN?
    http://www.aspfaq.com/2126

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Jim in Arizona" <com> wrote in message
    news:phx.gbl... 
    I'd 
    Our 
    matter 
    is 
    put 


    Aaron Guest

  3. #3

    Default Re: Database access using SQL 2000, ASP and IIS 5

    Set what timeout? There are several different timeouts that you may be
    reaching.
    http://www.aspfaq.com/2066

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Jim in Arizona" <com> wrote in message
    news:#phx.gbl... 
    idea? 
    error 
    > > I'd [/ref][/ref]
    server. 
    > > matter [/ref][/ref]
    that [/ref][/ref]
    'NT [/ref][/ref]
    Login [/ref][/ref]
    to 
    > >
    > >[/ref]
    >
    >[/ref]


    Aaron Guest

  4. #4

    Default Re: Database access using SQL 2000, ASP and IIS 5

    Thanks Aaron. That solved my connection problem, but now I've got another
    problem: Timeout.

    I set my timeout to 9000 seconds from 900 but I still seem to get the
    occasional timeout after lesst han 90 seconds (not 9000 seconds). Any idea?
    I know I should probably be asking this on a different board but this error
    is happening while doing a query on a sql database so I thought you may be
    able to help.

    Thanks,
    Jim

    "Aaron [SQL Server MVP]" <noraa> wrote in message
    news:phx.gbl... 
    > I'd 
    > Our 
    > matter 
    > is 
    > put 
    >
    >[/ref]


    Jim Guest

  5. #5

    Default Re: Database access using SQL 2000, ASP and IIS 5

    That answered all my questions. Thanks for pointing me in the right
    direction.

    Jim


    "Aaron [SQL Server MVP]" <noraa> wrote in message
    news:phx.gbl... 
    > idea? 
    > error [/ref]
    > server. [/ref]
    > that [/ref]
    > 'NT [/ref]
    > Login [/ref]
    > to 
    >>
    >>[/ref]
    >
    >[/ref]


    Jim Guest

Similar Threads

  1. problems access an MS Access 2000 DB using ASP
    By Brad Pears in forum ASP Database
    Replies: 2
    Last Post: July 21st, 09:16 PM
  2. Access 2002 PDFWriter VBA Code w/WinXP does not work like Access 2000
    By Tony_VBACoder in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 30th, 07:44 PM
  3. Access 2000 or SQL Server 2000
    By Denis in forum ASP Database
    Replies: 1
    Last Post: January 25th, 03:38 PM
  4. Minimal permissions with an Access Database and 2000 server ?
    By Gilles LAMBERT in forum ASP.NET Security
    Replies: 2
    Last Post: October 23rd, 04:42 AM
  5. Installing Access 2002 with Access 2000
    By Wayne in forum Microsoft Access
    Replies: 4
    Last Post: August 21st, 04:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139