Database Mirroring (SQL Server 2005) within a Workgroup

Question

Database Mirroring (SQL Server 2005) within a Workgroup

Steve White-418898

SSC Rookie

Points: 33
More actions
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 ?????

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

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

Luke79 SSCrazy Points: 2571 More actions · Answer 1

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.

Steve White-418898 SSC Rookie Points: 33 More actions · Answer 2

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

Luke79 SSCrazy Points: 2571 More actions · Answer 3

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

Steve White-418898 SSC Rookie Points: 33 More actions · Answer 4

Masterkey has same password on both machines.

How do I set a password for the certificate ?

Matthew Burger-340397 Valued Member Points: 73 More actions · Answer 5

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.

David Kearns Newbie Points: 3 More actions · Answer 6

David Kearns

Newbie

Points: 3

April 4, 2007 at 9:27 am

#698573

Helped me big time. Thanks!