Re: ASP Impersonation - null user
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 13:25:37 +0200
Not Me
Was your SQL Server set up with Windows Authentication only?
"Not Me" <Not.Me@xxxxxxxxxxxxxxx> wrote in message
news:1166521469.754869@xxxxxxxxxxxxxxxxxxxx
Hi, this could be an ASP, IIS or SQL server question so please bear with
me!
We have an sql server 2000 machine and our IIS 6 machine running
seperately but on the same domain. I can connect fine to the database
without using impersonation, but when it's enabled I get the error:
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
I've tried looking into this, and noted suggestions of copying accounts to
the database server machine.. is this really necessary? they're on the
same domain, and that would be lots of hassle as I'm hoping to allow
anyone on the domain access to the pages, with authorisation being ran
against the sql server roles/security groups.
Hope my query makes sense.. for info when I check
System.Security.Principal.WindowsIdentity.GetCurrent().Name I get the
expected result.
cheers for any help,
Chris
.
- Follow-Ups:
- Re: ASP Impersonation - null user
- From: Not Me
- Re: ASP Impersonation - null user
- References:
- ASP Impersonation - null user
- From: Not Me
- ASP Impersonation - null user
- Prev by Date: ASP Impersonation - null user
- Next by Date: Re: ASP Impersonation - null user
- Previous by thread: ASP Impersonation - null user
- Next by thread: Re: ASP Impersonation - null user
- Index(es):
Relevant Pages
|
|
