Dialogue security Vs Transport Security

Hi

I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?

Thanks

Pl. chk the post

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=608211&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425871&SiteID=1

HTH

Paritosh

|||

Transport security only secures the TCP connections between two hosts. Dialog security secures the dialog end to end between services. Since dialogs can span multiple hosts (eg> when there are forwarders in the middle), there is a need to secure the communication end-to-end. Use full dialog security unless you have a reason to use anonymous or unsecure. Books online will tell you what are the special cases when you may not want full security.

Also, why are you using Service Broker instead of Replication Services for solving your problem?

|||

Thanks for the response.

Using Service broker because it is not just replication, sometime routing and other things have to be managed.

Other reason is the scale and complexity of the environment, we can have around 2500 SQL distributed databases all over converging in to one central database.

Cheers!