Posted by Matt on 12/07/06 03:42

I have been using an ASP application to access a SQL 2000 database in
order to write records to it. I recently installed SQL 2005 on a
different server and when I redirect my ASP connection to the new
server I get the following error message:

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

I have added the domain\iusr_account on the SQL server but that didn't
change anything. Server is set to use both SQL adn Windows
Authentication... what am i missing??

thanks

• Next in forum: Re: SQL 2000 Bulk Insert attempt on FTP in progress
• Prev in forum: Re: SQL 2000 Bulk Insert attempt on FTP in progress
• Thread view: Authentication Issue with IIS

[Reply to this message]