Problem Accessing HTTP Endpoint from Info-Path

richard_nh — Fri, 29 Aug 2008 10:32:52 GMT

Hello All,

I have set up an HTTP Endpoint on SQL Server 2005 using the following standard method:

Set up the Web Service

Now we will need to create the web service. We will use the web service to store discounts into the DB from InfoPath.The Web Service in SQL Server is created through an “HTTP Endpoint” and a T-SQL stored procedure.Here is the stored procedure

create procedure StoreDiscount

@ShopId numeric,@StartDate datetime,@EndDate datetime,@DiscountRate intasBEGINinsert into discounts values(@ShopId,@StartDate,@EndDate,@DiscountRate)END

And here is the HTTP Endpoint:

CREATE ENDPOINT discount_endpoint

STATE = STARTEDAS HTTP ( PATH = '/sql', AUTHENTICATION = (INTEGRATED ), PORTS = ( CLEAR ), SITE = 'YourSqlServerName' )FOR SOAP ( WEBMETHOD 'StoreDiscountData' (name='infocityhall.dbo.StoreDiscount', SCHEMA=STANDARD ), WSDL = DEFAULT, SCHEMA = STANDARD, DATABASE = 'infocityhall', NAMESPACE = 'http://tempUri.org/' )

The web service will now be discoverable at the location http://yoursqlservername/sql?wsdl

____________....

However, all I get when I try to access the HTTP Endpoint either from an IE Browser or the Data Connection Wizard in Info-Path is a login prompt (which lets me go no further, even though username and password are correct) .

Web Services

Problem Accessing HTTP Endpoint from Info-Path