Wednesday, March 7, 2012

How to add a TCP endpoint in SQl Server 2005 Beta 2

Hi All,

I would like to know the syntax of creating an endpoint in SQL Server 2005 Beta 2 version.

The syntax which i am using is as follows:

create endpoint yuk1
state = started
as TCP
(
LISTENER_PORT = 4022
)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE trpyuk1)

And i am getting the following error :

Incorrect syntax near 'CERTIFICATE'.

Regards
Deepak

You are using beta 3 syntax. Is there any reason why you are trying to use beta 2?|||Hi,

Ok, thanks for the update. SO is this syntax ok for the June Community Version?

Regards
Deepak|||Yes.

-mike

No comments:

Post a Comment