Re: Question on session_end()?
From: bruce barker (nospam_brubar_at_safeco.com)
Date: 12/30/04
- Next message: PJ Olson: "Re: Failed Complie due to locked DLL"
- Previous message: tshad: "Re: Align right increasing height of cell"
- In reply to: Henry: "Question on session_end()?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 11:10:56 -0800
when session_end fired, its not tied to a request, so the thread runs as the
asp.net account. the default setup is that asp.net does not have access to
sql (unless you used standard security).
you have a several of options.
1) use standard or mixed security, and use standard security in the connect
string in this routine
2) impersonate a domain account with permission to the sqlsever before
making the call
3) run all sql thru a fixed domain account, <authentication mode="Windows"
userName="domain\account" password="myPassword />
4) change the asp.net account to a domain account
5) if ii6, use a pool account
7) leave asp.net as local, but give it a known password, and create a
matching local account on the sqlserver
-- bruce (sqlwork.com)
"Henry" <Henry@discussions.microsoft.com> wrote in message
news:AE6CD454-C1D3-47F7-9DE2-BA45C85CC8BD@microsoft.com...
| I have a question on session_end. I'm trying to log into my database when
| the session times out, it will store user info into a table. When I got
step
| into a line where I was trying to open connection (I had it set to timeout
in
| 1 minute, and ran it in debug mode), nothing happens. I read somewhere
before
| about how database call can't work with these settings in my web.config
file.
| I'm using <authentication mode="Windows" /> and <identity
| impersonate="true"/>. Is this true? If true, is there any other way to
call
| my stored procedure (sql server) to log user information in session_end?
| Thanks in advance.
|
| Henry
|
- Next message: PJ Olson: "Re: Failed Complie due to locked DLL"
- Previous message: tshad: "Re: Align right increasing height of cell"
- In reply to: Henry: "Question on session_end()?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
