locked
can any body help me with this (microsoft sql server error 1412 ) , RRS feed

  • Question

  • I am using Certificates for Mirroring : I applied certificates first and then backup ,restore  them with no recovery option and start mirroring :

     

     

    Sunday, June 5, 2011 7:04 AM

Answers

  • Can you show us entire error message?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by whatsUpYO Sunday, June 5, 2011 7:49 PM
    Sunday, June 5, 2011 7:14 AM

All replies

  • Can you show us entire error message?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by whatsUpYO Sunday, June 5, 2011 7:49 PM
    Sunday, June 5, 2011 7:14 AM
  • now I am getting error 1418 ,


     CREATE master key encryption by password ='password';
    ---------------------------------------------------------------------

    create certificate mirrirCert_cert with subject ='somethingforMirroring';

    -----------------------------------------------------------------------------

    CREATE endpoint endpoint_Miroring state = started
    as TCP( Listner_pory = 7024 ,listner_IP =all)
    for datanase_Mirroring( authentication =certifiacate mirrorCert_cert
    , encryption= required algorithm aes, role = all);

    -------------------------------------------------------------

    BACKUP certificate MirrorCert_cert to file = 'c:\MirrorCert1.cer'

    ----------------------------------------------

    cREATE login Login_Mirroring with password = 'password';

    -----------------------------------------------------------------------

    cerate user login_Mirroring for login login_mirroring

    -------------------------------------------------------------------
    CREATE certificate mirrorCert_cert

    autorization Login_mirroring

    from file = 'c:\MirrorCert1.cer'

    ----------------------------------------------------------------

    GRANT connect on endpoint ::Endpoint_mirroring to login_mirroring;

    ---------------------------------------------------------------------------


    ALTER database mirrorCert set partner = 'tcp://domain:7024';

    -- so far I did all these in principle and mirror but why to use 7024 here not 5022 or 5023??  why to create login ?? Do I have to login as Login_Mirroring to start Mirroring or I can use my domain account :??

     

     

     

     

     

     

     

     

     

     

     

     

    Sunday, June 5, 2011 7:50 PM