Do I need to enable a Service Broker endpoint on SQL 2005 to use SQLCacheDependency?

Question

Hi All,

My question really has three related parts which I hope you can help me clear up -

1. Do I need to enable a Service Broker endpoint on SQL 2005 to use the SQLCacheDependency mechanism?

2. If so, is there a specific port that needs to be used?

3. If neither of the web server machine and sql server are in a domain, what type of authentication is required, if at all? Certificates?

Thanks in advance
Kevin

Answer 1

No you don't need enable a service broker endpoint to use the SQLCacheDependency. A Service Broker Endpoint is only used to send SQL Service Broker messages from one instance to another.