Question on synching through RDA using port 1433

Hi,

Does SQL mobile require port 1433 to be open for RDA? I was under the impression that all synching occured through port 80. But when 1433 is restricted a connection cannot be completed.

I may be missing something really simple. My understanding of tcp/ip networking concepts are not very solid.

Thanks,

Tony.

Ok here is how things work in RDA.

Legend:

1) SQL Server Mobile/Everywhere on Client Box/Device - M1

2) IIS Box - M2

3) SQL Server Box - M3

M1, M2, M3 can be anywhere. That is, they can be on different machines or can be on same machine.

Communication Protocol [M1, M2] is HTTP or HTTPS.

Communication Protocol [M2, M3] is SQL OLEDB Connection (means port 1433).

I hope I am not too cryptic and you got what you want out of this! If not, let me know.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

|||

M2 and M3 are on the same box on a remote server, and when we restrict port 1433 externally through our firewall it appears to cause the synch to fail.

Any ideas on why this would occur?

Thanks.

|||

If IIS Server and SQL Server are on the same server only the Port 80 needs to be opened up in the Firewall to allow the HTTP/HTTPS messages.

Incase the IIS Server and the SQL Server are on different servers and there is a firewall between Internet and IIS Server, and another firewall between IIS Server and SQL Server then Port 80 needs to be opened up in the Internet Firewall, and Port 80 & 1443 needs to be opened up in the Firewall between IIS Server and SQL Server.

Can you verify if the information given above applies in your network topology

Regards

Ambrish