The user 'sa' does not have permission to register endpoint 'sql_endpoint' on the specified URL. Please ensure the URL refers t

I am trying to create an endpoint with sa

CREATE ENDPOINT sql_endpoint

STATE = STARTED

AS HTTP(

PATH = '/sql',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'SERVER'

)

FOR SOAP (

WEBMETHOD 'GetSqlInfo'

(name='master.dbo.xp_msver',

SCHEMA=STANDARD ),

WEBMETHOD 'DayAsNumber'

(name='master.sys.fn_MSdayasnumber'),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'master',

NAMESPACE = 'http://tempUri.org/'

);

WilliamTell

I also get an error while registering an endpoint.

I realized that the IIS was using the ports. When I stopped IIS Admin service I could resigter the endpoint.

http://www.kodyaz.com/content/createendpoint.aspx

Eralper
neoret
Hi,

http://sqljunkies.com/WebLog/ktegels/archive/2005/04/14/11616.aspx

HTH; Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
The user 'sa' does not have permission to register endpoint 'sql_endpoint' on the specified URL. Please ensure the URL refers t