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?
Answer by Nick Kavadias ·
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.
Answer by Jay Bonk ·
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