Windows Auth to SQL Server from ATL Web Service not working...

I have a web service that I've created using ATL Server (Visual Studio
2005 running on Windows 2003). The web service has NTLM auth on and
anonymous turned off. the app pool its in is running under a local
machine account. I'm trying to access SQL Server on a different
machine. When I hit the web service with a simple test application,
it appears to authenticate me and had the LOGON_USER equal to the
account I'm logged on as. However, when the database call happens, it
looks as though these credentials are not flowing to SQL as the event
log on the SQL box has a security audit failure with the account being
anonymous.

Can someone please help me understand how I can flow credentials (they
could even be the one the application pool in iis is running under) to
SQL on a different box from my web service in an Atl Server web
service.

thanks,

Mike
.

Relevant Pages

  • RE: Unable to connect to MSSQL...return error
    ... U SQL is using the windows integration security, but your web service is ... Use mixed security mode in sql server, create a new sql db account, use ... Give the SQL access permission to ASPNET account or NEtworkService ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: ATL server support in the next version of vs.net?
    ... future is .net then how do one move an ATL Server Web Service app to .net? ... oledb which I can attest that works great from an ATL Web Service! ... "ATL Server support has been removed from this version of Visual Studio. ...
    (microsoft.public.vc.atl)
  • Re: Conversion of VC++ ATL COM to .Net web service
    ... > converts the ATL COM to .Net web service. ... ATL Server handles web services in a totally different way ... > The intention is to avoid a line to line code conversion. ...
    (microsoft.public.dotnet.general)
  • Re: ATL server support in the next version of vs.net?
    ... You can find it at codeplex ... "The Visual C++ team is very pleased to announce the release of ATL Server ... constrain the functionality of ATL Server to fit within Visual C++ product ... future is .net then how do one move an ATL Server Web Service app to .net? ...
    (microsoft.public.vc.atl)
  • Re: ATL server support in the next version of vs.net?
    ... ATL Server is now "shared source". ... all the features and functionality you want to ATL Server and you can even ... future is .net then how do one move an ATL Server Web Service app to ... compared with oledb which I can attest that works great from an ATL Web ...
    (microsoft.public.vc.atl)
Loading