I have a network with NO domain controller. I have created an http endpoint using sql 2005. I can access the wsdl locally but when i try to access it from another box, i get a username and password prompt.
1) what is the account info its asking for to login to the service
2) is there an easier way to do this
below is the query used to create the endpoint:
CREATE ENDPOINT sql_auth_endpoint
STATE = STARTED
AS HTTP (
SITE = 'dmg-sql1',
PATH = '/sql',
AUTHENTICATION = (integrated),
PORTS=(clear)
)
FOR SOAP (
WEBMETHOD 'GetPurchaseOrder'
(
name='AdventureWorks.dbo.GetPurchaseOrder',
schema=STANDARD
) ,
WSDL = DEFAULT,
DATABASE = 'AdventureWorks',
BATCHES=ENABLED
)