SQL Server 2014 on a Domain Controller ?

Thinking to install a SQL instance on your Domain Controller ? Think twice, as it got bad implication if you do.

I will quote the Microsoft’s article: (there )

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

That mean that you will have to create an Active Directory account to run the service with higher right than a local 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.

Plan it right, don’t plan to add an ADDS’s server on your SQL’s server, as you will end up to create another server in the end. Planning it right to prevent unplanned cost to your customer.

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

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.

Now we fall into the limitation.

As you can see you are winner to plan your deployment correctly 🙂

ps. there it’s another reference there that show that it’s not something new.

Thanks
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s