Introduction

Welcome

System requirements

Licensing details

What is the registration

Using ASPRunner.NET

Working with projects

Connecting to the database

Datasource tables

Master-detail

Choose pages

Login page

User login settings

Avanced Security Settings

User group permissions

Fields order and totals

Miscellaneous settings

Choose theme

Visual Editor

About

Toolbars

Page Elements

"View as" settings

"Edit as" settings

Validation types

Lookup wizard

Events

Output directory settings

After you done

FTP upload

FrontPage Publishing

Advanced topics

Master-details relationship

AJAX-based Functionality

Connecting to database

Connecting to MS Access database

Connecting to MS SQL Server database

Connecting to MySQL database

Connecting to Oracle database

Publishing ASP.NET application to the remote Web server

Using FTP client to publish ASP.NET pages to the remote Web server

Using FrontPage to publish ASP.NET pages to the remote Web server

Demo Account

What is the Demo Account

Terms and conditions

Events

More about events

Predefined actions

Send simple email

Send email with new data

Save new data in another table

Insert a record into another table

Check if specific record exist

Display a message on the WEB page

Redirect to another page

Custom code

Sample code

Show list of customer orders

Before deleting a record check if related record exist

Check if start date is earlier then end date

Speed up data entry using events

Order ASPRunner.NET online

Error: Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'

Question:

I receive the following error message when open pages generated by ASPRunner.NET:

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'. /tablename_list.aspx, line xxx

Answer:

Issue

When using an ODBC or OLE DB connection to a Microsoft SQL Server database in an ASP.NET page, one of the following error messages may occur when viewing the page in a Web browser:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WebServerName\IUSR_computername'.

 

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

 

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

Reason

These errors are generated if SQL Server does not accept the logon account and/or password being submitted. One possible reason could be that a corresponding SQL Server account has not been setup for the Windows NT account used to access the database. An example of an account used to access the SQL Server database could be the IUSR_computername account used by Internet Information Services (IIS) for anonymous access to ASP pages.

Solution

Verify that a SQL Server authentication login or a Windows NT authentication login exists in SQL Server for the Windows user account that IIS uses to access the ASP page. If a login does not exist, use the SQL Server Enterprise Manager to create it. Also, when creating an ODBC Data Source Name (DSN) in the ODBC Administrator, make sure to choose the appropriate authentication method when you configure the DSN and to test the DSN in the ODBC Administrator to verify that it is working correctly.

 

 

For information on how to configure SQL Server authentication or Windows NT authentication for SQL Server, please refer to the following Microsoft Knowledge Base articles:

Q247931 INF: Authentication Methods for Connections to SQL Server in Active Server Pages

Q183060 INF: Troubleshooting Guide for 80004005 and Other Error Messages

Additional information

For additional information about authentication methods and how they work, please refer to Understanding Anonymous Authentication and the IUSR Account (TechNote 15378) and WWW Authentication Methods (TechNote 15383), or the online IIS documentation.