|
Home > Archive > IIS Server Security > March 2005 > Database access using SQL 2000, ASP and IIS 5.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database access using SQL 2000, ASP and IIS 5.
|
|
| Jim in Arizona 2004-11-01, 5:53 pm |
| Not sure what group to post this to so ... starting here.
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
| |
| Infodon 2005-03-23, 6:09 pm |
| Have you established the anonymous user account in SQL server??
"Jim in Arizona" wrote:
> Not sure what group to post this to so ... starting here.
>
> 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
>
>
>
|
|
|
|
|