Database Login Fail - Weird Problem
From: Mythran (kip_potter_at_hotmail.comREMOVETRAIL)
Date: 02/17/05
- Next message: Karl Seguin: "Re: Optimizing ViewState"
- Previous message: William F. Robertson, Jr.: "Re: read number from a string"
- Next in thread: bruce barker: "Re: Database Login Fail - Weird Problem"
- Reply: bruce barker: "Re: Database Login Fail - Weird Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Feb 2005 11:27:25 -0800
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
- Next message: Karl Seguin: "Re: Optimizing ViewState"
- Previous message: William F. Robertson, Jr.: "Re: read number from a string"
- Next in thread: bruce barker: "Re: Database Login Fail - Weird Problem"
- Reply: bruce barker: "Re: Database Login Fail - Weird Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
