User Not associated with a trusted SQL Server connection
- From: pat_whitted@xxxxxxxxxxx
- Date: 18 Jan 2006 08:28:58 -0800
I have a .Net app running on a Win2K3 server, with .Net framework
1.1.4322. On a separate Win2K3 server, were are running SQL 2000, with
no service packs (don't tell me about it - its a customer requirement).
The .Net app connects using a SQL login account, which has been granted
all the necessary permissions on the objects in the database. The SQL
server is configured for SQL and Windows authentication, and the
web.config file has the impersonate value set to true. EVERY page I hit
returns the "Error Message: Login failed for user 'App_WebUser'.
Reason: Not associated with a trusted SQL Server connection." The
killer is, this works perfectly on our test servers, but I can't get it
to work in another environment with identically (as far as I can tell)
configured servers. I've seen a ton of postings about this, and they
all talk about mixed mode, versus WIndows only auth, so I've verified
all of that, and verified that the LoginMode key in the registry is 2.
Anybody have any other suggestions? Thanks! - Pat
.
- Prev by Date: Re: creating server alias without Client Tools installed?
- Next by Date: Re: Connection pooling & transaction context
- Previous by thread: creating server alias without Client Tools installed?
- Next by thread: Re: Connection pooling & transaction context
- Index(es):
Relevant Pages
|
Loading
