You are trying to connect to an endpoint to perform an ad hoc SQL query. You are able to connect, but when you try a query, it fails to execute. Your endpoint creation script looks as
CREATE ENDPOINT sql_endpoint
STATE = STARTED
AS HTTP(PATH = '/sql',
AUTHENTICATION = (INTEGRATED),
PORTS = ( CLEAR ),
SITE = 'SERVER')
FOR SOAP ( WEBMETHOD 'GetSqlInfo'
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = 'master',
NAMESPACE = 'http://tempUri.org/')
What needs to be corrected with the endpoint settings?
Change the authentication to Kerberos.
Change the WSDL to custom through stored procedures.
Change the state attribute.
Add a parameter for batches to be enabled.
Change the database to the correct execution database.
You are executing a query that needs to provide the results, with no attributes at all. The results should contain the namespace for the data. Which option would you use?