Solved

MS SQL 2008 mirroring in WORKGROUP or DOMAIN

Posted on 2009-05-20
3
839 Views
Last Modified: 2012-05-07
Hi,

I am in a weird situation where my customer needs an SQL mirroring solution on new HW, and this config is for end user. But end user is a large company, where all information circle very slow, so they are not yet sure, whether they want this install to be in their AD domain, or should be SQL mirroring stand-alone solution in a small workgroup topology.

Now, my suggestion was to first decide about DOMAIN or WORKGROUP, then we will provide exact plan and offer. But they are in a hurry, offering bids will end next week, and I am not sure what to do with it.

Now, my concern:
What if we install and configure SQL mirroring onto 2 new servers, with additional witness workstation, so everything will work OK in an off-site location...then we move working equipment to end-user's facilities, and they decide that they want to have everything setup inside their local domain?
Ok, there is no need to do DCPROMO in any scenario, but it *might* be necessary to make existing SQL mirroring servers part of local domain. What problems may I expect? What scenarios to assume?

Ideas welcome.
0
Comment
Question by:Andrej Pirman
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Americom earned 500 total points
ID: 24434976
I'm assuming you are referring to SQL 2008 Cluster install of mirror.
Since you are going to use SQL 2008, you are fine as this version do not require to have a Domain for installation and configuration. You can set it up and tested first while document all the account used to configure the required services. Assuming you sue locall account and not domain account. If later you move to the domain, you can joint the domain and the account used on the services would still be okay. Of course, this version also allow you to change and configure the services to operate with domain account as well. See here for more info: http://msdn.microsoft.com/en-us/library/ms143504.aspx
0
 
LVL 18

Author Comment

by:Andrej Pirman
ID: 24439114
Americom, thanx for info. That is what I was looking for.
0
 
LVL 18

Expert Comment

by:Americom
ID: 24441021
You welcome. Glad that help.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Synchronize a new Active Directory domain with an existing Office 365 tenant
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question