ASP Impersonation - null user

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,
ChrisNot Me
Was your SQL Server set up with Windows Authentication only?
"Not Me" <Not.Me@.nada.nope.hk.za> wrote in message
news:1166521469.754869@.ucsnew2.ncl.ac.uk...
> 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
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%237eitB2IHHA.1280@.TK2MSFTNGP04.phx.gbl...
> "Not Me" <Not.Me@.nada.nope.hk.za> wrote in message
> news:1166521469.754869@.ucsnew2.ncl.ac.uk...
[vbcol=seagreen]
> Was your SQL Server set up with Windows Authentication only?
Aha, I'll check with the admin... was just reading up on how mixed-mode is
required in some circumstances, is this what you're getting at?
cheers,
Chris|||Yes. you can changed it and re-connict again
"Not Me" <Not.Me@.nada.nope.hk.za> wrote in message
news:1166527936.903888@.ucsnew2.ncl.ac.uk...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%237eitB2IHHA.1280@.TK2MSFTNGP04.phx.gbl...
>
> Aha, I'll check with the admin... was just reading up on how mixed-mode is
> required in some circumstances, is this what you're getting at?
> cheers,
> Chris
>
>|||Hmmm, it is already in mixed-mode.
Any other ideas?
cheers,
Chris
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1vPDJ2IHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes. you can changed it and re-connict again
>
> "Not Me" <Not.Me@.nada.nope.hk.za> wrote in message
> news:1166527936.903888@.ucsnew2.ncl.ac.uk...
>|||http://support.microsoft.com/?kbid=555017
http://www.microsoft.com/technet/pr...ds/default.mspx
"Not Me" <Not.Me@.nada.nope.hk.za> wrote in message
news:1166532551.477926@.ucsnew2.ncl.ac.uk...
> Hmmm, it is already in mixed-mode.
> Any other ideas?
> cheers,
> Chris
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e1vPDJ2IHHA.4712@.TK2MSFTNGP04.phx.gbl...
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eyAiGA3IHHA.3268@.TK2MSFTNGP04.phx.gbl...
> http://support.microsoft.com/?kbid=555017
Is that really necessary? it mentions non-domain web environments? all
servers are on the same domain. Seems lengthy for what I imagine to be a
very simple task.
[vbcol=seagreen]
> http://www.microsoft.com/technet/pr...ds/default.mspx[/vbco
l]
A tad more direction would help, there's hundreds of downloads! (it does
have the latest service pack)
cheers,
Chris