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
)