Solved

MS SQL 2008 mirroring in WORKGROUP or DOMAIN

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Last week, our Skyport webinar on “How to secure your Active Directory” (https://www.experts-exchange.com/videos/5810/Webinar-Is-Your-Active-Directory-as-Secure-as-You-Think.html) provided 218 attendees with a step-by-step guide for identifying Acti…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 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