We're using Enterprise Application Block June 2005 w/ Visual Studio 2003 .NET.
We've configured our ASP.NET web service to run under a specific domain
account using the instructions at
All connections to SQL Server are set to be TRUSTED. The debugger shows that
the main web service threads are (correctly) running under the specified
domain account and they are able to connect to Sql Server. But the polling
thread created for the watcher is running under the local ASPNET account.
As a result, we get login for (null) user failed SqlException when the
ConfigurationCh angeWatcher::Po ller() function invokes the
GetCurrentLastW riteTime() function in which an attempt is made to connect to
the db.
What do we need to do to get the polling threads (or for that matter any
threads that are spawned by our code) to use the credentials as specified in
the web.config file?
The ConfigurationCh angeWatcher::Po ller() function is non-virtual and private
and so we can't do it by deriving our own class and overriding the function.
Thanks,
Vijay Varadan
We've configured our ASP.NET web service to run under a specific domain
account using the instructions at
All connections to SQL Server are set to be TRUSTED. The debugger shows that
the main web service threads are (correctly) running under the specified
domain account and they are able to connect to Sql Server. But the polling
thread created for the watcher is running under the local ASPNET account.
As a result, we get login for (null) user failed SqlException when the
ConfigurationCh angeWatcher::Po ller() function invokes the
GetCurrentLastW riteTime() function in which an attempt is made to connect to
the db.
What do we need to do to get the polling threads (or for that matter any
threads that are spawned by our code) to use the credentials as specified in
the web.config file?
The ConfigurationCh angeWatcher::Po ller() function is non-virtual and private
and so we can't do it by deriving our own class and overriding the function.
Thanks,
Vijay Varadan