Dealing with the ASP.NET "Login failed for user <MachineName>\<User>'" error
Nov
29
Written by:
11/29/2007 3:53 PM
If you are reinstalling Microsoft SQL Server 2005 Express on a server running ASP.NET and Plesk, when you try to view an ASP.NET web page, you might see a message like the following:
Cannot open database "TellUWhen" requested by the login. The login failed.
Login failed for user 'MIGHTYMOUSE\IWAM_plesk(default)'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Syste.Data.SqlClient.SqlException: Cannot open database "TellUWhen" requested by the login. The login failed. Login failed for user 'MIGHTYMOUSE\IWAM_plesk(default)'.
The basic solution to the problem is to make sure that the specified user name (e.g. ASPNET or IWAM_plesk(default)) is a member of the SQLServer2005MSSQLUser$server$SQLExpress group.
Here are the specific steps to do this for the user "<User>" on "<MachineName>":
- Right-click "My Computer" and choose "Manage".
- Navigate to "Local Users and Groups\Users\<User>".
- Right-click on and select Properties.
- Select the "Member Of" tab.
- Click on Add > Advanced > Find Now.
- Select SQLServer2005MSSQLUser$<MachineName>$SQLExpress. Click on OK and OK to add this user to this group.
- Close the Computer Management window and restart IIS (or reboot the computer).
- Revisit the problem web page. It should work now.