Monday, February 25, 2008

Microsoft SQL 2005 Mirroring with No Domain (Hint Only)

Problem

Micorosft SQL 2005 provides database mirroring with automated fail-over (if you are using a witness server). This is really a great feature and I use it quite a bit at work. But sometimes we don't have a domain controller.

Can we do Mirroring without a domain controller?

Solution (Hint):

Yes you can! You can use the Certificates authentication. This is described in the MSDN article entitled.

How to: Allow Database Mirroring to Use Certificates for Outbound Connections (Transact-SQL)

at this URL http://msdn2.microsoft.com/en-us/library/ms186384.aspx

You can also find this information on SQL Books Online (BOL) on your SQL Server Management Studio at the local URL of ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/49239d02-964e-47c0-9b7f-2b539151ee1b.htm (To type in this URL, bring up the Index part of the help manual browser where you will see the URL field.)

We were able to get this configuration up and running, but there were two things that we ran into that stumbled us a bit.
  • Initially the clocks of two machines were quite a bit off. This causes a havoc with certificates.
  • Even though we did not have to rely on the Domain Controller, we still had to add the Fully Qualified Domain Name (FQDN) of the servers in our DNS server.
Post a Comment