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]

TJS wrote:

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.

--
-- Justin Lovell

[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...b;en-us;316989

--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ o n l i n e . m i c r o s o f t . c o m

"TJS" <no****@here.com> wrote in message
news:vo************@corp.supernews.com...

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