Posted by Najm on 08/30/07 20:24

On Aug 30, 3:26 pm, SQLMan_25 <naj...@gmail.com> 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...

[Back to original message]