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

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" wrote in message
news:OJSMUuowEHA.2540@TK2MSFTNGP09.phx.gbl...
> 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
>
>
>

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" wrote in message
news:#CvSntqwEHA.3908@TK2MSFTNGP12.phx.gbl...
> 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]" wrote in message
> news:eElfG1owEHA.1392@tk2msftngp13.phx.gbl...
> > Why are you using a DSN?
> > http://www.aspfaq.com/2126
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "Jim in Arizona" wrote in message
> > news:OJSMUuowEHA.2540@TK2MSFTNGP09.phx.gbl...
> >> 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
> >>
> >>
> >>
> >
> >
>
>

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]" wrote in message
news:eElfG1owEHA.1392@tk2msftngp13.phx.gbl...
> Why are you using a DSN?
> http://www.aspfaq.com/2126
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Jim in Arizona" wrote in message
> news:OJSMUuowEHA.2540@TK2MSFTNGP09.phx.gbl...
>> 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
>>
>>
>>
>
>

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]" wrote in message
news:OCsPtwqwEHA.2192@TK2MSFTNGP14.phx.gbl...
> 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" wrote in message
> news:#CvSntqwEHA.3908@TK2MSFTNGP12.phx.gbl...
>> 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]" wrote in message
>> news:eElfG1owEHA.1392@tk2msftngp13.phx.gbl...
>> > Why are you using a DSN?
>> > http://www.aspfaq.com/2126
>> >
>> > --
>> > http://www.aspfaq.com/
>> > (Reverse address to reply.)
>> >
>> >
>> >
>> >
>> > "Jim in Arizona" wrote in message
>> > news:OJSMUuowEHA.2540@TK2MSFTNGP09.phx.gbl...
>> >> 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
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>