Re: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- From: Dominick Baier [DevelopMentor] <dbaier@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 15:17:25 +0000 (UTC)
he never mentioned he is impersonating in asp.net - so no delegation needed. Cassini runs with the credentials of the interactive user - which seems to have access to sql - in contrast to the local ASPNET account - which i am trying to tell him since 2 days....
yes - use explicit credentials and enable mixed mode auth in sql server to get this to work.
---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com
I assume when you used filesystem, you had IE running on the same box
as the web server so there was just a single hop for authentication
and thus delegation was not needed. I also assume filesystem runs
with your credentials - not ASPUSER but I'm not an expert on ASP.Net.
Your problem could be either ASPUSER not having permissions or
delegation. The easiest solution for either one is to setup a SQL
Server authenticated login and try connecting by putting the user name
and password in the connection string. If that works you at least know
what the problem is and can try to address it.
<CLarkou@xxxxxxxxx> wrote in message
news:1142922538.964796.18230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I tried creating a website with FILE SYSTEM, not HTTP, and I was able
to open the web page in IE with SQL server data. ASPUSER is used for
connecting to the SQL SERVER machine with FILE SYSTEM web site ?
.
- Prev by Date: pfx certificate chain problem
- Next by Date: Re: Role based security flaw?
- Previous by thread: Re: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- Next by thread: Role based security flaw?
- Index(es):
Relevant Pages
|
