FIX: Validation of service accounts takes a long time when you set up SQL Server 2012

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard

Symptoms


Consider the following scenario:
  • You have a user account in a Windows domain.
  • You have a child domain of the Windows domain.
  • You disable the option "Active Directory Domain Controller - LDAP (TCP-In)" in the child domain.
  • You try to use the user account as the service account when you run the SQL Server setup file on a computer that is running Windows 2008 R2 or Windows 7 or later versions.
In this scenario, the validation of service accounts takes a long time.

Cause


The issue occurs because the Windows API NetQueryServiceAccount is called repeatedly and each call takes more than 80 seconds to complete when the option "Active Directory Domain Controller - LDAP (TCP-In)" is disabled.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 8 for SQL Server 2012 SP1


NoteThis fix is contained within the SQL Server Setup Support files that can be installed before the installations of SQL Server, this fix is also applied to the RTM installations of SQL Server.

Status


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

Workaround


To work around the issue, use local system account as service account when you set up a stand-alone instance of SQL Server 2012.