Re: Database Connection - Not Associated With Trusted Connection
- From: Scott Allen <scott@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 04 Oct 2005 23:40:50 -0400
I'm trying to keep track of the machine and network hops involved, but
it sounds like you are facing the dreaded double hop issue trying to
impersonate the user.
If you must carry the client's identity all the way to the database,
you'll need to use delegation. I have pointers here:
http://odetocode.com/blogs/scott/archive/2005/02/24/1053.aspx
If you don't need to client's identity there are easier options
available...
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 4 Oct 2005 16:37:03 -0700, "Mythran"
<kip_potter@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>I have a test server and a development machine. I have SQL Server installed
>on both, the installations are pretty much identical. Both servers are in
>the same domain. When I run my application locally, I can connect to the
>local sql server as well as the sql server on the test server. The IIS
>settings on both the test server and local machine are the same (anon
>disabled, use integrated windows auth). Identity impersonate is on in
>web.config.
>
>When I run the application on the test server, I can connect to the test
>server with the following connection string:
>"server=testing;trusted_connection=yes;". However, when I point it to my
>local machine ("server=mymachine;trusted_connection=yes;") I get the "Login
>failed for user '(null)'. Reason: Not associated with a trusted SQL Server
>connection." error.
>
>Using the same two connection strings on my local machine work fine. The
>only difference I know of is...the test machine is a child domain
>(test.mydomain) while my local machine is under the primary domain
>(mydomain). I can connect to it locally, but it can't seem to pass the
>credentials from the test machine to my local machine...it sees it (can see
>it using SQLBrowseConnect api function) and can connect to it using SQL
>Query Analyzer using windows authentication through Terminal Services, but
>it just doesn't work using ASP.Net :(
>
>Can anyone help?
>
>Thanks,
>Mythran
>
>
.
- References:
- Prev by Date: generated jscript link and urlencode
- Next by Date: RE: datalist radio group
- Previous by thread: Database Connection - Not Associated With Trusted Connection
- Next by thread: Re: Database Connection - Not Associated With Trusted Connection
- Index(es):
Relevant Pages
|
