Any limitations on EndPoint Creation par instance

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

Re: Any limitations on EndPoint Creation par instance

On Aug 30, 3:26 pm, SQLMan_25 wrote:
> 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

I figured out there could be only one endpoint...