Database Login Fail - Weird Problem

[Mythran]

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

 

[bruce barker]

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

-- bruce (sqlwork.com)

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