SQL WebService for Infopath form

rspowell460 — Tue, 05 Feb 2013 01:13:38 GMT

I have created a SQL endpoint to submit data to a SQL database using a webmethod. When I try to access the Service I get a "Windows Security" box that asking me to authenticate? When I try to authenticate, it just bounces back. First, why am I getting a "Windows Security" box anyway.

Below is my EndPoint Code with the webmethod.

CREATE ENDPOINT   MyEndPoint
AUTHORIZATION [Domain\User]
STATE = STARTED
AS HTTP
(
   PATH = '/WebServices/',
   AUTHENTICATION = (INTEGRATED ),
   PORTS = ( CLEAR ),
   SITE = '+'
   --SITE = 'MySite'
)

FOR SOAP

(WEBMETHOD 'http://MySite/'.'MyEndPoint'
(NAME='DB.dbo.MySPROC', SCHEMA=STANDARD ),
   --WSDL = DEFAULT,
   WSDL = 'MySPROC',
   BATCHES = DISABLED,
   SCHEMA = STANDARD,
   DATABASE = 'DB',
   NAMESPACE = 'http://MySite/WebServices/',
   CHARACTER_SET = XML
)

Web Services

SQL WebService for Infopath form