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) .