System.Data.SqlClient.SqlException: Login failed for user 'MachineName\ASPNET'

But I have registered as an administrator for my machine and then execute the Web application.

A very interesting thing is that I have met this problem (not the above application) before and it happened one after the other. That is, it worked one, then failed ("Login failed for user ..."), then worked again.

Who knows what happened is ASP.NET for this situation?

BTW: I have give full control to the account MachineName/ASPNET
I am working with Visual Studio 2003

Is MachineName/ASPNET accound is added in list of logins in SQL Server

Charul Shukla

And what privileges does MachineName\ASPNET have in SQL Server...

Thanks for you responses.

In SQL Server Enterprise Manager,

Database:pubs
Users: existing-> dbo (Login name sa), guest(no Login name)
I added user account -> machinename\ASPNET. But Login Name is not shown.
In Permissions: SELECT, INSERT, UPDATE, etc, all.
In Database role membership: public, db_owner, db_accessadmin, etc, all.

I also added a user account ASPNET (Login name is shown as ASPNET). Gave full access.

But still : Login failed for user 'MACHINENAME\ASPNET'.

In fact I just run examples from Microsoft and the database pubs is there in SQL Server.



Have a nice weekend!