I need help in configuring Service broker in sqlserver 2008. My requirement is to transfer data from one sql web server to another web server. I have followed the all steps like created master key, message type, queue and certificate. but when i try to create end point like
CREATE ENDPOINT ServiceBrokerEndPoint STATE=STARTED AS TCP (LISTENER_PORT = 1433) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE EndPointCertificateA, ENCRYPTION = SUPPORTED );
I get Error : Msg 1088, Level 15, State 1, Line 1 Cannot find the object "EndPointCertificateA" because it does not exist or you do not have permissions. but i can see the sertificate under security tab of the database. how to solve this. I'm using windows xp with sql server 2008.