Login failed for user

[flagsiup]

I am doing the visual studio.net walkthrough for web
application(msde sql server). I am getting the error
message:

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

The code line to connect as created by the project is:

Me.SqlConnection1.ConnectionString = "workstation
id=DJCR5F41;packet size=4096;integrated
security=SSPI;data source=""dj" & _
"cr5f41\vsdotnet"";persist security
info=False;initial catalog=pubs"

Would appreciate knowing how to get the program to
recognized the DJCR5F41\ASPNET

thanks

 

[Cor Ligthert]

Hi Flagsiup,

Which walkthrough is that DJCR5F41 in, than we can look at it, there are a
lot of walktrhoughs,

Cor

 

[flagisup]

Chapter four the first one. This is the walkthrough book
that comes with vs.net 2003. It is abending on
sqlDataAdapter1.Fill(dSet). The msde is working find
because I can bring up the data that populates the grid.
It is somehow expecting to see the DJCR5F41\ASPNET.
Could this be a part of the folder security?

thanks for any help

 

[Guest]

I have subsequently applied DJCR5F41\ASPNET to the folder
security but still getting the same login error message

 

[flagisup]

I have subsequently applied DJCR5F41\ASPNET to the folder
security but still getting the same login error

 

[Val Mazur]

Hi,

Could be two issues. First is that ASPNET account does not have permissions
to access SQL Server (MSDE). Second - your MSDE is not configured for use
with Windows Authentication. Could be both cases in one. See next KB about
how to resolve these issues

http://support.microsoft.com/default.aspx?scid=kb;en-us;316989&Product=adonet

http://support.microsoft.com/default.aspx?scid=kb;en-us;321698&Product=aspnet

 

[Guest]

Thanks Val, you were right on both counts. The aspnet
must be a member of the administrators group and in my
case I needed to change my registry setting to mix mode.