Login failed for user 'MyPC\ASPNET'. msg received

[Dee]

Hi,
I am running sample code from 101 VB.NET. The sample is an ASP.NET porj that
uses SQL Server I added ASPNET user to all the Groups including
Administrator. I don't know why I get this error. I get the message when the
code tries to access sql server: da.Fill(dsProducts).
don't know The Windows Forms part accesse the database fine. Anyone else has
come across this issue?
Thanks.
Dee

 

[Mark Fitzpatrick]

Have you associated the ASPNET account in SQL Server? SQL Server itself is
saying it doesn't recognize this account trying to access it. In the SQL
Server Enterprise manager, map this account to the SQL Server login or don't
use a trusted connection and use a connection string with a valid SQL Server
user and password embedded instead.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Brock Allen]

I'd suggest reading this entire thread. It explains what's going on, and
a way to fix this.

http://groups-beta.google.com/group...Brock+ASPNET+database&rnum=1#9c72794fbca0d600

 

[Dee]

Thanks very much Brock I will read this.
Good luck
Dee

 

[Dee]

Thanks Mark, appreciate your help.
Dee

Have you associated the ASPNET account in SQL Server? SQL Server itself is
saying it doesn't recognize this account trying to access it. In the SQL
Server Enterprise manager, map this account to the SQL Server login or don't
use a trusted connection and use a connection string with a valid SQL Server
user and password embedded instead.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Guest]

Solution for your problem:

in Web.config file use this>
<authorization>
<deny users="?" />
</authorization>
<identity impersonate="true" />

it should work...

 

[Dee]

Thanks Newton.

Solution for your problem:

in Web.config file use this>
<authorization>
<deny users="?" />
</authorization>
<identity impersonate="true" />

it should work...