envirvorment:
XP sp2, IIS 5, sql server 2005 dev edition.
1, created a end point
CREATE
ENDPOINT sql_endpoint
STATE
= STARTED
AS
HTTP(
PATH = '/sql_endpoint',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR )
)
FOR
SOAP (
WEBMETHOD
'GetAllUser'
(name='test2k.dbo.p_endpoint_test'), -- procedure is created before
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = 'master',
NAMESPACE = 'http://localhost/'
);
2, add web service reference in visual studio 2005
3, debug, get exception:
{"The request failed with HTTP status 401: Unauthorized."}
any suggestion?
Thanks