Posted by SQLMan_25 on 08/30/07 19:26

Hi All,
I am trying to create multiple endpoints for mutiple database that has
service broker enabled. It allows me to create only one endpoint for
service broker then i get the following error:

Msg 7862, Level 16, State 1, Line 1
An endpoint of the requested type already exists. Only one endpoint
of this type is supported. Use ALTER ENDPOINT or DROP the existing
endpoint and execute the CREATE ENDPOINT statement.
Msg 7807, Level 16, State 1, Line 1
An error ('0x800700b7') occurred while attempting to register the
endpoint 'ServiceEndpoint'.

code that is failing:

CREATE ENDPOINT ServiceEndpoint
STATE = STARTED
AS TCP
(
LISTENER_PORT = 4742
)
FOR SERVICE_BROKER
(
AUTHENTICATION = WINDOWS
)
GO

Here is code that created first endpoint successfully:

CREATE ENDPOINT OrderEndpoint
STATE = STARTED
AS TCP
(
LISTENER_PORT = 4740
)
FOR SERVICE_BROKER
(
AUTHENTICATION = WINDOWS
)
GO

I am using SQL Server 2005 dev edition SP2 on XP professional.

Thanks in advance for your help.

-Najm

[Back to original message]