You canot install SQL Server 2008 R2 by using a service account when only an RODC is reachable

Applies to: SQL Server 2008 R2 DatacenterSQL Server 2008 R2 DeveloperSQL Server 2008 R2 Enterprise

Symptoms


Consider the following scenario:
  • You have a perimeter network (also known as a DMZ, demilitarized zone, and a screened subnet) that only has a read-only domain controller (RODC) available.
  • You have a member server in the perimeter network.
  • You try to install Microsoft SQL Server 2008 R2 on the member server, and you use an Active Directory service account for the SQL Server service.

In this scenario, when the installation program validates the user account, the installation wizard fails.

Workaround


To work around this issue, use the built-in account to install SQL Server. Then, change the account that is used for the services to an Active Directory service account.

References


2032911  You may encounter problems when you install SQL Server on a domain controller

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.