How can I avoid impersonation?

[James Park]

I have two servers, both running IIS6 and SQL Server 2000. I copied a
website over from one to the other. Everything works fine on the source
server, but on the target server opening a page that requires database
access gives me something like "Login failed for NT AUTHORITY/NETWORK
SERVICE." When I set impersonation to true in the web.config, the page works
fine, but I didn't need to use it before. What's the difference? I can
supply more information about the problem if need be, I just don't know
what's important and what's not.

[Steve C. Orr [MVP, MCSD]]

I'd say you need to compare the security settings in both IIS and SQL Server
for both servers. Clearly your settings are not the same on both servers.

--
I hope this helps,
Steve C. Orr
MCSD, MVP, CSM
http://SteveOrr.net
"James Park" <ja********@redwhale.comwrote in message
news:e8**************@TK2MSFTNGP03.phx.gbl...

>I have two servers, both running IIS6 and SQL Server 2000. I copied a
website over from one to the other. Everything works fine on the source
server, but on the target server opening a page that requires database
access gives me something like "Login failed for NT AUTHORITY/NETWORK
SERVICE." When I set impersonation to true in the web.config, the page
works fine, but I didn't need to use it before. What's the difference? I
can supply more information about the problem if need be, I just don't know
what's important and what's not.