Error message when you create a trusted data connection from ASP.NET to SQL Server: "Login failed for user: 'AccountName'"

Article translations Article translations
Article ID: 316989 - View products that this article applies to.
This article was previously published under Q316989
Expand all | Collapse all

On This Page

SYMPTOMS

When you create a trusted connection from Microsoft ASP.NET to Microsoft SQL Server, you may receive the following error message:
Login failed for user 'MachineName\ASPNET
For computers that run Internet Information Services (IIS) 6.0, you may receive the following error message:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
Note You receive either of these error messages specifically when you use integrated security (when you include the integrated security=sspi attribute in a connection string).

CAUSE

When you use ASP.NET, the default security context is the ASPNET account (or NetworkService account, for an application that runs on IIS 6.0) for both Aspnet_wp.exe (or W3wp.exe, for an application that runs on IIS 6.0) and the request to SQL Server. By default, the ASPNET account (or NetworkService account, for an application that runs on IIS 6.0) does not have any permissions in SQL Server, and therefore it cannot access the database.

RESOLUTION

To resolve this issue, use one of the following methods:
  • Method 1 Programmatically change the security context of the ASP.NET worker process to a user who has the correct SQL Server permissions.
  • Method 2 Change the default configuration of ASP.NET so that the ASP.NET worker process starts and runs under the context of a user who has the correct permissions in SQL Server.
  • Method 3 Grant the correct permissions in SQL Server so that the ASPNET account (or NetworkService account, for an application that runs on IIS 6.0) has the appropriate access to the required resources.

    Note This method will make all the Web applications on the server have the corresponding right on the computer that is running SQL Server.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to reproduce the issue

  1. Create a new Microsoft Visual Basic .NET Web application on a computer that is running both ASP.NET and SQL Server.
  2. Add the following code to the Page_Load event of the Webform1.aspx page that was created by using the project:
    Dim con As New System.Data.SqlClient.SqlConnection("data source=localhost;integrated security=sspi;database=northwind")
     con.open()
     con.close()
  3. Build the project, and then open the Webform1.aspx page in the browser.
  4. You receive the error message that is mentioned in the "Symptoms" section.

REFERENCES

For more information about how to programmatically change the security context of the ASP.NET worker process, click the following article numbers to view the articles in the Microsoft Knowledge Base:
306158 How to implement impersonation in an ASP.NET application
307002 ASP/ODBC/SQL Server error 0x80040E4D "Login failed for user '(null)'"
253500 "Client unable to establish connection" error message when connecting from ASP to SQL Server
306586 Troubleshooting error 80004005 "Login failed" in ASP
247931 Authentication methods for connections to SQL Server in Active Server Pages
315158 FIX: ASP.NET does not work with the default ASPNET account on a domain controller
824308 BUG: IWAM account is not granted the impersonate privilege for ASP.NET 1.1 on a Windows 2000 domain controller with SP4
For more information about how to change the default configuration of the ASP.NET security context, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms978378.aspx
For more information about how to add the ASPNET account to SQL Server, see the "Adding a Windows User or Group" topic in SQL Server Books Online.

Properties

Article ID: 316989 - Last Review: September 21, 2007 - Revision: 5.7
APPLIES TO
  • Microsoft ASP.NET 1.1
  • Microsoft ADO.NET 1.1
  • Microsoft ASP.NET 1.0
  • Microsoft ADO.NET (included with the .NET Framework)
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft ADO.NET 2.0
Keywords: 
kberrmsg kbfaq kbhttpruntime kbnofix kbprb kbsecurity KB316989

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com