Re: Securing Merge Replication

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 05/04/04 

Date: Tue, 04 May 2004 17:44:48 GMT

Previous post:
"a) what are the secured protocols supported by SQL Merge Replication?
 b) What are the various options available to perform SQL Merge replication
over secured channel (sftp,SSL etc) ?
  
c)If we use Force Encryption on SQL Server then other applications on that
server are affected with drop in performance...
d) Is there any other way to secure Merge replication...

a) SSL, IPSec
b) SSL, VPN
c) Yes. You would need to measure the change in performance as it varies
upon hardware and resources. I would recommend
reviewing the performance of your application and database design before
spending time on performance hit related to protocol encryption.

d) SSL, VPN, IPSec.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • RE: local admin account password
    ... > encrypt the database and create alerts in the event of unsuccessful ... >> no more recovery console and don't think cached logins will work. ... >> The DB file would be encrypted with EFS so only the limited user SQL ... >> itself doesn't really need to be secure as the authentication is based ...
    (Focus-Microsoft)
  • Re: Replicating very large articles but need to avoid locks from s
    ... thank you for the response and tip regarding snapshot processing. ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replicating very large articles but need to avoid locks from s
    ... snapshot processing will be inadequate to scale (it is not a pretty sight ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
    (microsoft.public.sqlserver.replication)
  • Re: local admin account password
    ... >> except its based on something specific about the server. ... >> more recovery console and don't think cached logins will work. ... >> The DB file would be encrypted with EFS so only the limited user SQL ... >> and the app itself doesn't really need to be secure as the ...
    (Focus-Microsoft)
  • Re: clustering enquires
    ... Another 3rd party option is LifeKeeper Protection Suite for SQL Server from ... The benefits of host based replication from LifeKeeper is that you don't ... In addition, LifeKeeper can support Active/Active clustering, Cascading ...
    (microsoft.public.sqlserver.clustering)
Quantcast