Simple thread issue?



I have an file based asp.net application the creates a thread to do some
background printing. It works fine but when the application is deployed on a
web server, the following error occurs in the thread when it accesses SQL:

Login failed for user ''. The user is not associated with a trusted SQL
Server connection.

Note the blank user. It seems that the new thread does not have the
credentials but looking at "Thread.CurrentPrincipal", there is a valid user
(me).

Is there something I am missing? Does the application need some assembly
permissions? I wonder if there are any settings under IIS? Is there any way
of telling why SQL cannot access the thread credentials?

Brian


.



Relevant Pages

  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... Just wanted to add a final note that, though it might be ok to run SQL CE ... All apps and web server, SQLCE 3.1 run on the same machine. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... It's the point that SQL CE not designed for the situation like a web server ... And we expect worst case is like 10 connections. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)
  • Re: Query Kills webserver but SQL server runs fine?
    ... >I have a query that looks for addresses in a table and retrieves any of the ... Address1, such as when you are looking for only a street. ... SQL Server MVP ... Only our web server is affected and has to be restarted. ...
    (microsoft.public.sqlserver.programming)
  • Re: fox pro, odbc, remote web server, firewall
    ... There is a cisco2600 first, then theres a web server in the dmz, then a pix ... 506e behind that and a sql box behind that. ... I cannot install fox pro on the web server. ... > IDE needs to be installed on the web server for the Visual FoxPro OLE DB> provider to work. ...
    (microsoft.public.data.odbc)
  • Re: FS: hardlinks on directories
    ... > wide range of purposes, lets say web, ftp, sql, name one. ... > hardlinking all web in one single webtree, all sql in one single sql tree ... If you web server got hacked, how do you prevent the hack from ADDING ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)