web matrix and msde

[TJS]

I am trying to run an asp.net page connecting to MSDE.

Whenever I try to run the page under IIS server I get the following error:

Login failed for user 'yourcomputer\ASPNET'.

I can make a connection to the database and view the tables
I have mixed mode set in registry - what else is required ?

 

[Justin Lovell]

I am trying to run an asp.net page connecting to MSDE.

Whenever I try to run the page under IIS server I get the following error:

Login failed for user 'yourcomputer\ASPNET'.

I can make a connection to the database and view the tables
I have mixed mode set in registry - what else is required ?

Go to the root directory of your application, right-click and select
security. Add the IIS anonymous user with the ASPNET user to have read
and read/write respectively.

 

[TJS]

I don't see anywhere to add someone -
the dialog only offers anonymous access, on or off

 

[Dino Chiesa [Microsoft]]

It seems to me you are having a login problem at the database, not the
filesystem.
You need to add the ASPNET user to the database.

The ASPNET account needs to be added as a trusted login into the SQL
Server Logins group. This can be done with osql:

sp_addlogin [ @loginame = ] 'login'
[ , [ @passwd = ] 'password' ]
[ , [ @defdb = ] 'database' ]


see
http://dbforums.com/arch/72/2002/5/367811
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;316989