Webservice SQL logon fails on production IIS server
From: Tim Baley (TimBaley_at_discussions.microsoft.com)
Date: 02/11/05
- Next message: Ken: "Post XML to Webservice"
- Previous message: venkat: "WSE Runtime Installation Check!"
- Next in thread: Martin Kulov: "Re: Webservice SQL logon fails on production IIS server"
- Reply: Martin Kulov: "Re: Webservice SQL logon fails on production IIS server"
- Reply: D. Brown: "RE: Webservice SQL logon fails on production IIS server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 08:31:05 -0800
I recently created some intranet web sevices to expose stored procedures on
our SQL Servers (SQL2k). The stored procedures include an audit trail with
user/login identification, so the web services are set up for Windows
integrated authentication. The web sevices work well when they are hosted on
IIS on my Win2k Pro development machine. I have tried accessing the services
under several user accounts on several machines, including machines in other
zones connected by VPN. I have connected the webservices to different SQL
servers.
When I move the services to production IIS servers, the database connection
step throws an exception "Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'". The web service on the production service is not flowing the user
credentials through to SQL server. What do I need to do to get the service
to work?
Thanks,
Tim Bailey
Energy Laboratories, Inc.
- Next message: Ken: "Post XML to Webservice"
- Previous message: venkat: "WSE Runtime Installation Check!"
- Next in thread: Martin Kulov: "Re: Webservice SQL logon fails on production IIS server"
- Reply: Martin Kulov: "Re: Webservice SQL logon fails on production IIS server"
- Reply: D. Brown: "RE: Webservice SQL logon fails on production IIS server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
