Solved

MS SQL 2008 mirroring in WORKGROUP or DOMAIN

Posted on 2009-05-20
3
834 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 …

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now