RTM версия SQLServer 2005 не даст создать endpoint на занятом порте, в частности, при запушенном IIS, такой statement не работает ( с сообщением

Msg 7890, Level 16, State 1, Line 2
An error occurred while attempting to register the endpoint 'XXX'. One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict. )

CREATE ENDPOINT XXX
STATE = STARTED
AS HTTP(
PATH = '/sql',
PORTS = ( CLEAR ),
AUTHENTICATION = (INTEGRATED ),
SITE = '*'
)
FOR SOAP (
WEBMETHOD 'webMethodName'
(name='dbName.dbo.sp_Name'),
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = 'DBName',
NAMESPACE = 'http://tempUri.org/'

);

Конфликт между port listeners решается оператором CLEAR_PORT

CREATE ENDPOINT sql_endpoint2
STATE = STARTED
AS HTTP(
PATH = '/sql',
PORTS = ( CLEAR ),
CLEAR_PORT = 8090,
AUTHENTICATION = (INTEGRATED ),
SITE = '*'
)
...