locked
How to enable encryption in database mirroring? RRS feed

  • Question

  • I have configured the mirroring  after "Encrypt data sent through this end point " disable this option.

    Now I want to enable this but this option is coming as disable how to enable encryption?


    "SQLSERVER DBA" "INDIA"
    Monday, February 7, 2011 12:10 PM

Answers

  • ALTER ENDPOINT DBMirroringEndPoint
    FOR DATABASE_MIRRORING
    ( ENCRYPTION = REQUIRED ALGORITHM AES)
    • Marked as answer by Ajay.G Tuesday, February 8, 2011 10:19 AM
    Tuesday, February 8, 2011 7:18 AM

All replies

  • ALTER ENDPOINT DBMirroringEndPoint
    FOR DATABASE_MIRRORING
    (ENCRYPTION = REQUIRED);

    where DBMirroringEndPoint is the name of your end point

    Tuesday, February 8, 2011 4:33 AM
  • Thanks: but Error is :

    The RC4 encryption algo is not supported whwn running in FIPS compliance mode.


    "SQLSERVER DBA" "INDIA"
    Tuesday, February 8, 2011 6:08 AM
  • ALTER ENDPOINT DBMirroringEndPoint
    FOR DATABASE_MIRRORING
    ( ENCRYPTION = REQUIRED ALGORITHM AES)
    • Marked as answer by Ajay.G Tuesday, February 8, 2011 10:19 AM
    Tuesday, February 8, 2011 7:18 AM
  • Lots of Thanks

    I am able to do manual failover but not automatic failover using witness....showing (mirror,disconnected,inrecovery) with database name and database is not accesible also.


    "SQLSERVER DBA" "INDIA"
    Tuesday, February 8, 2011 8:26 AM
  • Sorry I have not applied in witness now its working Thanks Thanks...
    "SQLSERVER DBA" "INDIA"
    Tuesday, February 8, 2011 10:19 AM