Install Microsoft SQL Server
Windows HCK fully supports SQL Server 2012, and it recognizes any pre-installed instance of SQL Server 2008 R2, SQL server 2008 and SQL Server 2008 R2, 32-bit only.
HCKSetup.exe installs SQL Server 2012 Express with the correct parameters and configuration. If SQL is not installed, this is the preferred method. In addition, we recommended that you uninstall any previous versions of SQL from past HCK versions (such as WLK 1.6).
If you want to use a pre-installed instance of SQL server 2005 32-bit, you must manually modify the registry to bypass the HCKSetup detection that will otherwise block an attempt to install Windows HCK.
Configure SQL Server 2012
Setup.exe /QUIET /HIDECONSOLE /ACTION=install /FEATURES=SQL,RS /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /ASSVCACCOUNT="NT AUTHORITY\SYSTEM" /RSSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /INSTANCENAME=MSSQLSERVER /TCPENABLED=1 /NPENABLED=1 /X86 /IAcceptSQLServerLicenseTerms=1
Configure SQL Server 2008 R2
setup.exe /QUIET /HIDECONSOLE /ACTION=install /FEATURES=SQL,RS /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /ASSVCACCOUNT="NT AUTHORITY\SYSTEM" /RSSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS=BUILTIN\ADMINISTRATORS /INSTANCENAME=MSSQLSERVER /TCPENABLED=1 /NPENABLED=1 /IAcceptSQLServerLicenseTerms=1 /X86=True
Configure HCKSetup for SQL Server 2005 32-bit
Make sure that the default SQL named instance of “MSSQLSERVER” exists. Refer to the specific SQL instructions on how to check and create this, if necessary.
Manually edit the registry and add the following key: HKLM\SOFTWARE\wow6432Node\Microsoft\Microsoft SQL Server\100\Machines.
Launch hcksetup normally, select the kits to install, and complete the hcksetup installation.
Note
Due to a potential SQL Server 2005 backward compatibility version mismatch between the copy distributed with Windows HCK and the copy that may be preinstalled, we recommend that you uninstall any preinstalled versions of the kit before launching hcksetup. To uninstall SQL Server instances and SQL Server 2005 backward compatibility instances, click Control Panel, click Uninstall a Program, and then click Uninstall.