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

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.
DeeHave 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
"Dee" <dee@.home> wrote in message
news:utLIZ2YNFHA.508@.TK2MSFTNGP12.phx.gbl...
> 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
>
I'd suggest reading this entire thread. It explains what's going on, and
a way to fix this.
c72794fbca0d600" target="_blank">http://groups-beta.google.com/group...c72794fbca0d600
-Brock
DevelopMentor
http://staff.develop.com/ballen

> 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
Thanks very much Brock I will read this.
Good luck
Dee
"Brock Allen" <ballen@.NOSPAMdevelop.com> wrote in message
news:310461632478106700607392@.msnews.microsoft.com...
> 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...ramework.aspnet
/browse_thread/thread/d5add5600a526490/9c72794fbca0d600?q=Brock+ASPNET+datab
ase&rnum=1#9c72794fbca0d600
> -Brock
> DevelopMentor
> http://staff.develop.com/ballen
>
>
>
>
Thanks Mark, appreciate your help. :-)
Dee
"Mark Fitzpatrick" <markfitz@.fitzme.com> wrote in message
news:#diMp9YNFHA.3356@.TK2MSFTNGP12.phx.gbl...
> 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
> "Dee" <dee@.home> wrote in message
> news:utLIZ2YNFHA.508@.TK2MSFTNGP12.phx.gbl...
>
Solution for your problem:
in Web.config file use this>
<authorization>
<deny users="?" />
</authorization>
<identity impersonate="true" />
it should work...
"Dee" wrote:

> Hi,
> I am running sample code from 101 VB.NET. The sample is an ASP.NET porj th
at
> 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 t
he
> code tries to access sql server: da.Fill(dsProducts).
> don't know The Windows Forms part accesse the database fine. Anyone else h
as
> come across this issue?
> Thanks.
> Dee
>
>
Thanks Newton.
"Newton" <Newton@.discussions.microsoft.com> wrote in message
news:31CCDB8F-BF00-4DE3-810D-879DD6C4E43B@.microsoft.com...
> Solution for your problem:
> in Web.config file use this>
> <authorization>
> <deny users="?" />
> </authorization>
> <identity impersonate="true" />
> it should work...
> "Dee" wrote:
>
that
the
has