question

xweb avatar image
xweb asked

Setup Mirroring without a domain account

I will have 2 SQL 2005 Standard servers in a datacenter. I currently have 1 and am planning on an additional server for mirroring. These 2 machines will not be an active directory that I can have accesses to a shared user; it belongs to the hosting provider. I want to setup mirroring but have read (and tested locally) that the 2 servers should have the SQLSERVER service running under the same domain login. Since this is not possible in my setup, I am wondering what my options are.

The hosting privder suggested making one of my servers a domain controller and setting up users. I dont really want to manage that. I also read about generating certificates.

Any ideas for a working mirror setup, without a witness?

database-mirroring
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nick Kavadias avatar image
Nick Kavadias answered

You don't need AD. You can setup mirroring using certificates. See: http://msdn.microsoft.com/en-us/library/ms191140.aspx

Running SQL Server standard without a mirror basically leaves you with a single option. High Safety (synchronous) without automatic fail-over.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jay Bonk avatar image
Jay Bonk answered

You can setup mirroring using certificates when you're not a domain. If you set up mirroring without a witness, you aren't able to take advantage of High Availability mode, which buys you automatic failover. You can still configure mirroring to use High Protection or High Performance.

The link mentioned above by SQLNinjaSkillz provides the step by step instructions for setting up mirroring using certificated

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.