Solved

MS SQL 2008 mirroring in WORKGROUP or DOMAIN

Posted on 2009-05-20
3
842 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

690 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