I added my machine name aspnet account as a db owner on the database and i still cant login.  I am getting this error:

Cannot open user default database. Login failed.
Login failed for user 'F1J2J91\ASPNET'.

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: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'F1J2J91\ASPNET'.

 What can i do so i can login and play in this db as the one on the web doesnt work?  Thanks!

I also am getting this error. Anyone know a fix?

Thanks

I dont get this message if i run the application without debugging (ctrl+F5) but if i try to get to it outside of Visual Studio then i get the error.  I have given my aspnet user read & execute, list folder contents, and read permissions.  I have also attached the db to sql management studio express 05, added my machinename/aspnet user to the security tab, and added it as a user of the database as the db owner but it still wont work.

Any other thoughts?
 

Open your SQL Server Enterprize Manager Go to Logins

Add the user ASPNET with proper rights..

Goto SQL Server Management Studio then in Security then Login 

-Create User MachineName\ASPNET

And Then Assign Your Database Rights to This User

You dont need to create user ASP.NET, provided youinstall .net framework

Just you have to add it under sql server by Open Sql Server Managment Studio - > Security - >Login

Add here ASP.NET user (By searching it on ypur machine)

& register it by executing following command

Open VS command propmt - > aspnet_regiis -i

http://forums.asp.net/t/953255.aspx

Would a MSDN article do instead of a KB article?  If so, take a look at:

http://msdn2.microsoft.com/en-us/library/ms229862.aspx

Scott Guthrie also has a helpful blog entry on the process as well as all sorts of tips working with the Membership database:

http://weblogs.asp.net/scottgu/archive/2006/02/24/438953.aspx

http://forums.asp.net/t/1277454.aspx

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.