ASP Impersonation - null user
- From: "Not Me" <Not.Me@xxxxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 09:44:29 -0000
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: Uri Dimant
- Re: ASP Impersonation - null user
- Prev by Date: Re: Securing a SQL Server Database
- Next by Date: Re: ASP Impersonation - null user
- Previous by thread: Re: SQL 2000 securing records...
- Next by thread: Re: ASP Impersonation - null user
- Index(es):
Relevant Pages
|
