Post reply

Database Mirroring (SQL Server 2005) within a Workgroup

  • March 15, 2007 at 4:56 am

    #116253

    Hi,

    I am trying to set up database mirroring between 2 servers on the same subnet but not members of a domain - i.e. they are both in the default workgroup WORKGROUP.

    I have successfully implemented mirroring on the same boxes when they were both part of a domain - but obviously something extra needs to be done for my present configuration.

    I am using certificate authentication and am getting the 1418 error - the mirror server cannot be reached or doesn't exist.

    The network is fine and I can telnet both ways using the server names and port numbers

    Any Ideas ?????

     

     

     

  • March 15, 2007 at 2:50 pm

    #695355

    Make sure that certs match across all servers participating in the mirror session.  This includes optional witness server.  It's a bit trickier to setup in the workgroup.  We had experienced the same issue, and it was the certificate problem.  Probably password on one of them isn't matching.

     

  • March 16, 2007 at 3:20 am

    #695402

    Thank you for the reply. What do you mean by make sure the certificates match ?

    I created the certificates on each box by using:

    CREATE CERTIFICATE PrincipalCert

    WITH SUBJECT = 'SQL Server Mirroring Certificate fo Principal Server'

    and for the Mirror Server

    CREATE CERTIFICATE MirrorCert

    WITH SUBJECT = 'SQL Server Mirroring Certificate fo Mirror Server'

    I then backed these up and copied each of these to their partners C: drive.

    I then associated the cert with the appropriate login:

    CREATE CERTIFICATE MirrorCert

    AUTHORIZATION MirrorUser

    FROM FILE = 'C:\MirrorCert.cer'

    I did the opposite on the Mirror server.

    Am I doing something wrong or am I missing something ??

    Also - when you say the passwords may not match, what do you mean ?

    Many thanks in advance for your reply

     

     

     

     

  • March 16, 2007 at 6:36 am

    #695434

    How about the certificate password, it has to be the same across all three machines.  Also what about your master key?

  • March 16, 2007 at 6:40 am

    #695435

    Masterkey has same password on both machines.

    How do I set a password for the certificate ?

     

  • March 16, 2007 at 1:51 pm

    #695536

    We had the same issue with our mirror.  I used the following document from the Books which explained how to setup the certificates and it fixed our issue with connections.

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5d48bb98-61f0-4b99-8f1a-b53f831d63d0.htm

    Hope this helps.

  • April 4, 2007 at 9:27 am

    #698573

    Helped me big time. Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply