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 /en-us/help/2917531
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
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.
