IIS & SQL Issues
From: TipTop (aburley_at_speakeasy.net)
Date: 04/17/04
- Next message: John Smith: "Recommendation for an ASP.NET Forums Application?"
- Previous message: John Smith: "Re: How to access the Session object from a new thread ?"
- Next in thread: S. Justin Gengo: "Re: IIS & SQL Issues"
- Reply: S. Justin Gengo: "Re: IIS & SQL Issues"
- Reply: Chris Botha: "Re: IIS & SQL Issues"
- Reply: Ken Schaefer: "Re: IIS & SQL Issues"
- Reply: Michael P Phillipson: "Re: IIS & SQL Issues"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 17 Apr 2004 15:40:48 -0400
I am trying to use integrated Windows authentication and
impersonation to run a page that accesses SQL Server via integrated
security. It's not working -- sort of. I've set IIS security to
integrated Windows authentication (and unchecked the other options).
I've set the web.config to use Windows authentication and set
impersonation to true. The connection string includes Integrated
Security = SSPI. And it works... if you access the page from the same
machine. If you call the page over the network (even when logged in
under the same Windows account as when on the server), it fails with
the "Login failed for user '(null)'" error. I display the results of
Environment.UserName on the page (commenting out the sql connection
code so that it will run when calling it over the network), and in all
cases it shows the correct username. (I call the page over the network
and sure enough it displays my account name.)
- Next message: John Smith: "Recommendation for an ASP.NET Forums Application?"
- Previous message: John Smith: "Re: How to access the Session object from a new thread ?"
- Next in thread: S. Justin Gengo: "Re: IIS & SQL Issues"
- Reply: S. Justin Gengo: "Re: IIS & SQL Issues"
- Reply: Chris Botha: "Re: IIS & SQL Issues"
- Reply: Ken Schaefer: "Re: IIS & SQL Issues"
- Reply: Michael P Phillipson: "Re: IIS & SQL Issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
