Service Broker enabling issue

• ps.

  One Orange Chip

  Points: 29422

  More actions

  May 24, 2009 at 9:44 pm

  #134583

  Hello All,

  I'm unable to enable service broker under service area configuration....

  It says This instance does not have a service broker endpoint.

  Am using SQL 2k5 Developer edition RTM.

  ---

  
  Pradeep Singh

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  May 24, 2009 at 10:01 pm

  #999554

  This means the Service Broker is not installed on the server

  Check out:

  http://msdn.microsoft.com/en-us/library/ms166044.aspx

  http://msdn.microsoft.com/en-us/library/ms166043(SQL.90).aspx

  http://msdn.microsoft.com/en-us/library/ms166067.aspx

  Tanx 😀

• ps.

  One Orange Chip

  Points: 29422

  More actions

  May 24, 2009 at 10:04 pm

  #999555

  Thanks Eswin,

  I enabled service broker...

  from BOL :

  GO

  USE master;

  CREATE ENDPOINT BrokerEndpoint

  STATE = STARTED

  AS TCP ( LISTENER_PORT = 4037 )

  FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;

  GO🙂

  ---

  
  Pradeep Singh