Re: Database Login Fail - Weird Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: bruce barker (nospam_brubar_at_safeco.com)
Date: 02/18/05 

Date: Thu, 17 Feb 2005 17:44:30 -0800

if you want the asp.net pages to run under the asp.net account, don't set
identity impersonate to true.

-- bruce (sqlwork.com)

"Mythran" <kip_potter@hotmail.comREMOVETRAIL> wrote in message
news:uz5r3aSFFHA.2572@tk2msftngp13.phx.gbl...
| I keep getting the exception, "Cannot open database requested in login
| 'dbblah'. Login fails. Login failed for 'domain\user'".
|
| I have ASPNET setup as the user in IIS, identity impersonate is true in
the
| web.config file. The IUSR and ASPNET identities have read and execute
| permissions for the virtual directory's folder path.
|
| Here's the weird part, if I hit F5 (refresh) it prompts to retry posting
| back the form. I accept and it works fine. Every screen that connects
the
| database fails, when I refresh it works. CONFUSING!
|
| The ASPNET account has access to the database. No other user accounts do
| have access. This is the way we want it. Under the iis application for
the
| virtual directory we have set, the Anonymous user is set to domain\aspnet
| (domain being our domain). If I uncheck the "Integrated Windows
| authentication" checkbox, I don't get the error anymore and it works just
| fine.
|
| OS is Windows 2000 Server
| .Net Framework v1.1
|
| User set in machine.config is our aspnet account with the correct password
| set. The anonymous user set in iis also has the correct password set.
|
| Any help is appreciated :)
|
| Mythran
|
|

Relevant Pages