x

Can I inplment clustering with just 2 servers and one NAS ?

Hi,

I have the following architecture, it consists in only 2 servers, connected to a NAS.

![architecture][1] [1]: http://ask.sqlservercentral.com//upfiles/arch.gif

I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do the sql server complains...). Is there a way to implement clustering with these limitations?

more ▼

asked Dec 19, 2011 at 03:03 AM in Default

avatar image

RagnaRock
45 4 4 7

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. There are some limitations while installing SQL Server on a domain controller which includes

SQL Server failover cluster instances are not supported where cluster nodes are domain controllers

So, it seems you cannot do it.

Rest of the limitations are

  • On Windows Server 2003, SQL Server services can run under a domain account or a local system account.

  • You cannot run SQL Server services on a domain controller under a local service account or a network service account.

  • After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.

  • After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.

  • SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

more ▼

answered Dec 19, 2011 at 03:38 AM

avatar image

Sacred Jewel
1.7k 3 7 10

and is possible to implement clustering without a domain?

Dec 19, 2011 at 03:49 AM RagnaRock
(comments are locked)
10|1200 characters needed characters left

I have never tested this, but one way you may be able to deal with this if you are confined to just two physical servers is to set one of them up to run multiple virtual machines to support both a domain controller and SQL Server under different instances of the OS.

more ▼

answered Dec 19, 2011 at 08:00 AM

avatar image

TimothyAWiseman
15.6k 22 51 38

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2175
x13

asked: Dec 19, 2011 at 03:03 AM

Seen: 1111 times

Last Updated: Dec 19, 2011 at 03:03 AM

Copyright 2017 Redgate Software. Privacy Policy