SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


There was a failure to validate setting CTRLUSERS in validation function ValidateUsers


During SQL Server 2012 RC0 evaluation version installation, I got the following setup error : Error code 0x85640004.

SQL Server Setup failure.
There was a failure to validate setting CTRLUSERS in validation function ValidateUsers.
Error code 0x85640004.

There was a failure to validate setting CTRLUSERS in validation function ValidateUsers

At this point the installation stops and you have to start from beginning. What I can suggest for developers and administrators who want to install SQL Server 2012 RC0 and try it, is to install SQL Server Distributed Replay Client, but not to assign a user for Distributed Replay Controller service.





This error happened twice while I was trying to install the X86 edition of the latest SQL Server beta, SQL Server 2012 RC0 (aka Denali). When the setup process is at the configuration step of SQL Server Distributed Replay Client service permissions, when I click on the Add Current User button, I got the above error code although the current user is a local admin on the current machine.

error code 0x85640004 during SQL Server Distributed Replay Controller Service access permissions

Excluding the SQL Server Distributed Replay Client from the selected database components for installing SQL Server 2012 RC0 is an option for installing this new SQL Server release.

But I chosed to install SQL Server Distributed Replay Client but not to add the current user among authenticated users for Distributed Replay Controller service.



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.