Impersonate in ThreadPool

[Viorel Ghilas]

Hi all

I have an ASP.NET application that uses impersonate account to connect to
DB, this works good. But in some cases I need to put some methods in
ThreadPool. The methods from ThreadPool should do some foreground operations
with DB. But .NET throws me the sql exception "Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.". The
thread from pool in execution proccess has an ASPNET account different from
my impersonated account. How can I resolve this problem, do you have any
suggestions?

with best regards
Viorel

 

[Alvin Bruney [MVP]]

It is not resolvable in .NET currently. The spawned thread assumes the
identity of the calling process. I'm not aware of a fix for this situation.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok

 

[Viorel Ghilas]

Hi, I found the solution.It is simple

in state parameter in WaitCallBack I send WindowsIdentity.GetCurrent()

in method I use WindowsImpersonationContext from identity.Impersonate()
do some code than context.Undo()

it's simple and elegant

thx all

It is not resolvable in .NET currently. The spawned thread assumes the
identity of the calling process. I'm not aware of a fix for this situation.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi all

I have an ASP.NET application that uses impersonate account to connect to
DB, this works good. But in some cases I need to put some methods in
ThreadPool. The methods from ThreadPool should do some foreground
operations
with DB. But .NET throws me the sql exception "Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.".
The
thread from pool in execution proccess has an ASPNET account different
from
my impersonated account. How can I resolve this problem, do you have any
suggestions?

with best regards
Viorel

 

[Alvin Bruney [MVP]]

would you mind posting the relevant portions of the code?

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi, I found the solution.It is simple

in state parameter in WaitCallBack I send WindowsIdentity.GetCurrent()

in method I use WindowsImpersonationContext from identity.Impersonate()
do some code than context.Undo()

it's simple and elegant

thx all

It is not resolvable in .NET currently. The spawned thread assumes the
identity of the calling process. I'm not aware of a fix for this situation.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok
----------------------------------------------------------

Hi all

I have an ASP.NET application that uses impersonate account to connect to
DB, this works good. But in some cases I need to put some methods in
ThreadPool. The methods from ThreadPool should do some foreground
operations
with DB. But .NET throws me the sql exception "Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server
connection.".
The
thread from pool in execution proccess has an ASPNET account different
from
my impersonated account. How can I resolve this problem, do you have
any
suggestions?

with best regards
Viorel