J
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
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