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

"Dee" <dee@home> wrote in message
news:ut*************@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

[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/...72794fbca0d600

-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

[Dee]

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

"Brock Allen" <ba****@NOSPAMdevelop.com> wrote in message
news:31**********************@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/...amework.aspnet
/browse_thread/thread/d5add5600a526490/9c72794fbca0d600?q=Brock+ASPNET+datab
ase&rnum=1#9c72794fbca0d600
-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

[Dee]

Thanks Mark, appreciate your help. :-)
Dee

"Mark Fitzpatrick" <ma******@fitzme.com> wrote in message
news:#d**************@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:ut*************@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

[Newton]

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 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

[Dee]

Thanks Newton.

"Newton" <Ne****@discussions.microsoft.com> wrote in message
news:31**********************************@microsof t.com...

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 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