• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

MS SQL 2008 mirroring in WORKGROUP or DOMAIN

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
Andrej Pirman
Asked:
Andrej Pirman
  • 2
1 Solution
 
AmericomCommented:
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
 
Andrej PirmanAuthor Commented:
Americom, thanx for info. That is what I was looking for.
0
 
AmericomCommented:
You welcome. Glad that help.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now