ASPNET user

[John Hoge]

Hi,

I'm having trougble connecting a web application to SQL Server. The
connection string, "Provider=SQLOLEDB;Data Source=MYSERVER;Initial
Catalog=MYDB;" Integrated Security=SSPI;" seems to be fine.

I get an error message of:
System.Data.OleDb.OleDbException: Cannot open database requested in
login.

The IUSR account has logon rights to the the DB, and necessary exec
rights on the relevent stored procedures. I was reading that ASP.NET
uses an ASPNET account, but this account was not installed on my
server.
I've tried to modify the web.config to allow impersonation, so that
ASP.NET would act as if it were IUSR, but that doesn't work either.
<identity impersonate="true" />

I know there's a simple solution out there, with so many SQL servers
talking to ADO.NET, but it escapes me.

Thanks in advance,
John

 

[Guest]

I'm having almost exactly the same problem! For some reason my ASPNET account doesn't show up on my windows 2000 server when I install the .Net framework

Please help us!!!
Thank

See string: ASPNET user or group not created!

 

[John Hoge]

I found the answer to this. It seems that the .Net framework 1.1 no
longer has an ASPNET user, and works through the IWAM_Servername
account.