Sunday 19 February 2012

Confirming encryption when Replication is over SSL

We are using SSL to secure merge replication from client to server. Though
we can check through network monitor whether data is encrypted for normal
query to database, for replication how can we confirm that data is
encrypted - as data is already being send in binary format.
Could you please let me know how to check if data is encrypted when we do
replication over SSL.
Thanks,
Ganesh.Same process Ganesh. Run one of the Agents in Replication such as the
Distribution Agent and verify that the data being sent is encrypted using a
network sniffer or Microsoft Network Monitor. Running SQL Profiler will
show the data un-encrypted.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks Kevin.
Ganesh.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4bYLAiLEHA.2364@.cpmsftngxa10.phx.gbl...
> Same process Ganesh. Run one of the Agents in Replication such as the
> Distribution Agent and verify that the data being sent is encrypted using
a
> network sniffer or Microsoft Network Monitor. Running SQL Profiler will
> show the data un-encrypted.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

No comments:

Post a Comment