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
http://support.microsoft.com/default...b;en-us;329290
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
ConfigurationChangeWatcher::Poller() function invokes the
GetCurrentLastWriteTime() 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 ConfigurationChangeWatcher::Poller() 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