aspnet user missing

[Guest]

I want to be able to add the standard aspnet user as a database user, but it doesn't exist.
The box is windows 2000 advanced server running SQL Server 2000 with vs.net 2003 installed.
Surely vs.net 2003 would have installed this user wouldn't it

I can connect using sql server authentication, but isn't using "aspnet" user the preferred method?

Thanks in advance
Pooky

 

[Guest]

Dear Pooky

If you want to re-install aspnet account, well its quite simple. Go to VS.Net 2003 command prompt and typ
aspnet_regiis - i and give enter. this will reinstall the aspnet user

meanwhile if aspnet user is not there, are you able to open and work with the vs.net editor

----- Pooky wrote: ----

I want to be able to add the standard aspnet user as a database user, but it doesn't exist.
The box is windows 2000 advanced server running SQL Server 2000 with vs.net 2003 installed.
Surely vs.net 2003 would have installed this user wouldn't it

I can connect using sql server authentication, but isn't using "aspnet" user the preferred method?

Thanks in advance
Pooky