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.

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×