SQL Server Windows Logo Certification

This topic provides details about SQL Server certification for the Windows Server logo program. The following custom actions might be performed during SQL Server Setup operations.

Custom action	Description
CA_ErrorDifferentLang	Fails setup if product is installed in a different languages.
CA_ErrorNewerVersion	Fails setup if a higher version of the product is installed.
CA_ErrorPendingReboot	Not installed and pending file rename and skip pending reboot check.
CA_ErrorPrereqDotNet	Sets an MSI property to 1 if .Net 2.0 is not found and 0 otherwise.
CA_ErrorPrereqDotNet20Or30Or35Or40	Sets an MSI property to 1 if none of .Net 2.0 and 3.0 and 4.0 is found and 0 otherwise.
CA_ErrorPrereqDotNet20Or40	Sets an MSI property to 1 if none of .Net 2.0 and 4.0 is found and 0 otherwise.
CA_SetRefCountNewerFoundFlag	Sets an MSI property to indicate that a newer version of the product is installed.
CA_SetRefCountUpgradeFlag	Sets an MSI property to indicate that setup is doing an upgrade.
CallHlmExe	Calls Help Library Manager to create a SQL Server specific Help catalog that is used by Microsoft Help Viewer to display product documentation.
Commit_sqlRegHiveCopy	Deletes all registry keys under Microsoft\Microsoft SQL Server\TempKeys.
ControlService	Handles start and stop requests for the Win32 service.
ControlService_64	Checking for Services to Start or Stop.
DevenvSetup_VS	Registers Visual Studio packages used by the Visual Studio shell in SQL Server Data Tools.
DelimitProperty	Processes _sqlDelimitProperty table to delimit properties such as cutting trailing slash or adding #.
DelimitProperty_64	Delimit Properties.
DevenvSetup_VS_32_1033	Launches devenv.exe to install visual studio.
Do_HttpServiceSecurity	Enables accounts with logon as service rights to access HTTP and HTTPFilter by adding access control encryption (ACE).
Do_LogInstallStart	Records an event in event log indicating start of SQL Server installation.
Do_LogInstallStart_64	Record Install Start in Windows Event Log.
Do_sqlCopyXML	Updates XML files by copying elements or whole files from a source to a destination file.
Do_sqlCopyXML_64	Updates XML files by copying elements or whole files from a source to a destination file.
Do_sqlFileSDDL	Sets access control list (ACL) for files.
Do_sqlFileSDDL_64	Setting File Security for 64-bit processes.
Do_sqlFileSR	Does a search and replace within a given file (uses temp file in the process).
Do_sqlFileSR_64	Does a search and replace within a given file (uses temp file in the process).
Do_sqlLocalServers	Takes ownership of reflected registry keys related to local COM servers, to enable Side-by-side installation.
Do_sqlLocalServers_64	Registering local servers for 64-bit processes.
Do_sqlRegHiveCopy	Copies the registry hive to \Microsoft\Microsoft SQL Server\TempKeys (runs in system context) with no impersonation.
Do_sqlRegSDDL	Sets ACL for registries.
Do_sqlRegSDDL_64	Setting Registry Security for 64-bit processes.
Do_sqlServiceSDDL	Sets ACL for services.
Do_sqlServiceSDDL_64	Setting Service Security.
Do_sqlServiceSidType_64	Setting Service SID Type.
Do_sqlVerIndependentProgID	Repairs/restores the version-independent program ID for COM servers during side-by-side installation.
Do_sqlVerIndependentProgID_64	Restoring COM Servers for 64-bit processes.
Do_UpdateFeatureList	Sets registry with a list of features installed - key name is "FeatureList."
Do_UpdateFeatureList_64	Updating new feature state for discovery.
Do_UpdateTypeLib	Repairs registration of 64-bit typelib when installed side-by-side with 32-bit typelib.
Do_UpdateTypeLib_64	Registering type libraries.
DOTNETFW4MISSING_64	Sets an error message to "MDSMISSINGREDISTPREREQERROR" property when .NET Framework 4.0 is not installed.
EXCELMISSING_64	Sets an error message to "MDSMISSINGREDISTPREREQERROR" property when Excel is not installed.
GenerateFeatureList	Reviews feature table, inspects feature installation and action state, builds a list, and schedules actions.
GenerateFeatureList_64	Recording new feature state for discovery.
IsDotNetFramework20Installed	Determines whether .Net Framework versions 2.0, 3.0, 3.5, or 4.0 are installed.
IsDotNetInstalled	Determines whether any version of .Net Framework is installed.
IsDotNet20Installed	Sets an MSI property to 1 if .Net 2.0 is installed and 0 otherwise.
IsDotNet20Or40Installed	Sets an MSI property to 1 if .Net 2.0 or 4.0 is installed and 0 otherwise.
IsDotNetFramework20Or30Or35Or40Installed	Sets an MSI property to 1 if .Net 2.0 or 3.0 or 3.5 or 4.0 is installed and 0 otherwise.
IsPendingReboot	Checks if any files included in the MSI are contained in the operating system pending file rename key and sets a property with the list of those files.
IsPendingRebootKey	Sets PENDINGFILERENAME if a file from the MSI file table is in PFR registry value.
MISSINGMDSPREREQERROR_64	When there is any error message set to "MDSMISSINGREDISTPREREQERROR" property, shows an error dialog and stops installation.
Remove_NativeImage	Sets InstallNgenTicks property or schedules undo action (ignores error codes).
Remove_NativeImage_64	Removing Native Images
RemoveSupportFiles	Removes support files.
RemoveSupportFiles_64	Removing temporary files.
RestoreSetupParams	Retrieves parameters for a given product that was stored by Setup during a new installation.
RestoreSetupParams_64	Setting Internal Properties.
Rollback_sqlRegHiveCopy	Restores backup copy of registry hive in case of failure, ignores errors.
Rollback_UpdateFeatureList	Updates registry key FeatureList with feature list.
Rollback_UpdateFeatureList_64	Restoring feature state for discovery.
RollbackSupportFiles	Deletes support directory (WYukonBootstarpDir) registry key only. No files are deleted.
RollbackSupportFiles_64	Removing temporary files.
RSCA_SetRefCountUpgradeFlag	Sets a property to determine if the upgrade was from before Katmai SP2.
RSSP_CAInstall_64	Install the custom actions. This will register the Reporting Services components in SharePoint. This will restart the W3SVCservice.
RSSP_CAStreamBinary_64	To stream out and subsequently delete rscustom.exe.
RSSP_CATestRS (/t)	SQL Server Reporting Services 2005 only. Tests if the report server has a working connection to the report server database.
RSSP_CATestRS_64	SQL Server Reporting Services 2005 only. The switch tests if the report server has a working connection to the report server database.
RSSP_CAUninstall_64	Uninstall. This will unregister the Reporting Services components from the entire SharePoint farm but leave the files on disk. This will restart the W3SVCservice.
RSSP_CAUninstallLocal (/p)	Local uninstall. Unregisters the Reporting Services components from the local computer only. The files remain on disk. This will restart the W3SVCservice.
RSSP_CAUninstallLocal_64	Local uninstall. This will unregister the Reporting Services components from only the local computer. The files will remain on disk. This will restart the W3SVCservice.
RSSPTarget	Sets a property to the install directory for SharePoint.
SapBiOpenReadme	Invokes notepad.exe to open readme file.
SetCommonFilesDir_32	Set 32-bit common files directory.
SetCommonFilesDir_64	Set 64-bit common files directory.
SetErrorReporting	Set error reporting property.
SetInstanceProperty	Gathers known and newly set properties for a given instance of SQL Server and stores them in a table.
SetInstanceProperty_64	Setting Internal Properties.
SetProgramFilesDir_32	Set 32-bit program files directory.
SetProgramFilesDir_64	Set 64-bit program files directory.
SetSqlProgramMenuFolder	Set program menu folder property.
SetSqmReporting	Sets whether to enable SQM reporting.
SetSystemDir_32	Sets the Windows System directory property in 32-bit OS.
SetSystemDir_64	Sets the Windows System directory property in 64-bit OS.
SetVsIde10Dir_64	Sets an MSI property for visual studio 2010 IDE path.
SkipInstall	Stops the current Setup operation with a success code.
SkipInstallCA	Stops the current Setup operation with a success code.
SNAC_IAcceptSQLNCLILicenseTerms	Sets when the user accepts the SQL Server Native Access Client licensing terms.
SNAC_SetClientSSNLDefaults	Sets the default client-side SSNL defaults.
SqlFollowComponentsValidate	Creates a map of hierarchical component relationship.
SqlFollowComponentsValidate_64	Examining side-by-side Components.
Sqlmsirc_BackupAppGuid	Enumerates current application level dependencies on the running product and saves them in a property.
Sqlmsirc_BackupAppGuid_64	Enumerates current application level dependencies on the running product and saves them in a property.
Sqlmsirc_BackupAppGuid_NewerFound_64	Enumerates current application level dependencies on the running product and saves them in a property.
Sqlmsirc_CheckAppDependency	Checks if an application has a dependency on the current product and stops Setup if there is a dependency.
Sqlmsirc_CheckAppDependency_64	Checks if an application has a dependency on the current product and stops Setup if there is a dependency.
Sqlmsirc_CheckBrowserDependency	Sees if other products depend on the SQL Server Browser components, and blocks uninstallation if any are found.
Sqlmsirc_CheckFeatureDependency	Checks if there is an application that depends on a feature being removed and blocks uninstallation if there is.
Sqlmsirc_CheckFeatureDependency_64	Checking feature dependency.
Sqlmsirc_CheckLanguage	Enforces side-by-side language installation rules for SQL Server redistributable components.
Sqlmsirc_CheckLanguage_64	Enforces side-by-side language installation rules for SQL Server 2008 R2 redistributable components.
Sqlmsirc_Do_UpdateFeatureRefcount	A deferred action that updates the reference count in the registry.
Sqlmsirc_Do_UpdateFeatureRefcount_64	Updating feature reference count.
Sqlmsirc_NotifyFeatureStates	Sends a notification to the SQL Server Setup bootstrapper with the list of features that are being modified in the current transaction.
Sqlmsirc_NotifyFeatureStates_64	Generating a notification for all the features that will be changed during the current transaction.
Sqlmsirc_RefCountAppGuid	Adds a dependency to a product from another product that will be installed later, and stops the current Setup transaction with a success code.
Sqlmsirc_RefCountAppGuid_64	Adds a dependency to a product from another product that will be installed later, and stops the current Setup transaction with a success code.
Sqlmsirc_RefCountAppGuid_NewerFound_64	Adds a dependency to a product from another product that will be installed later, and stops the current Setup transaction with a success code.
Sqlmsirc_RegisterAppGuid	Adds a dependency to a product from another product that will be installed later, and allows Setup to keep running.
Sqlmsirc_RegisterAppGuid_64	Adds a dependency to a product from another product that will be installed later, and allows Setup to keep running.
Sqlmsirc_RegisterAppGuid_NewerFound_64	Adds a dependency to a product from another product that will be installed later, and allows Setup to keep running.
Sqlmsirc_RemoveBrowserGroup	Deletes the service group for SQL Server Browser.
Sqlmsirc_RestoreAppGuid	During upgrade, migrates the list of products that depended on the old version to the new version.
Sqlmsirc_RestoreAppGuid_64	During upgrade, migrates the list of products that depended on the old version to the new version.
Sqlmsirc_RestoreAppGuid_NewerFound_64	During upgrade, migrates the list of products that depended on the old version to the new version.
Sqlmsirc_Rollback_UpdateFeatureRefcount	A rollback action that reverts the registry keys that are used for reference counting if anything fails during installation.
Sqlmsirc_Rollback_UpdateFeatureRefcount_64	Restoring feature reference count.
Sqlmsirc_UpdatePackageRefcount	Registers dependencies upon other products during the installation, so that the uninstallation of those products will be blocked until the current product is uninstalled.
Sqlmsirc_ValidateAppGuid	Validates the syntax of the APPGUID property to ensure that it is a product code.
Sqlmsirc_ValidateAppGuid_64	Validates the syntax of the APPGUID property to ensure that it is a product code.
Sqlmsirc_ValidateAppGuid_NewerFound_64	Validates the syntax of the APPGUID property to ensure that it is a product code.
Sqlmsirc_Write_UpdateFeatureRefcount	An immediate action that collects data and schedules the other (Do and Undo) actions.
Sqlmsirc_Write_UpdateFeatureRefcount_64	Update the reference count in the DLL registry of the feature’s key file.
Sqlmsirc_Write_UpdatePackageRefcount	Schedules a deferred action.
StreamSupportFiles	Streams Setup support files from binary table.
StreamSupportFiles_64	Extracting custom action file from stream.
SqlSysClr_64	Sets an MSI property to indicate whether SQLSysClrTypes is installed.
SqlUninstall	Schedules a deferred CA to uninstall RBS.
Undo_NativeImage	Uninstalls native assembly.
Undo_NativeImage_64	Removing Native Images.
Undo_sqlLocalServers	Same as Do_sqlLocalServers.
Undo_sqlLocalServers_64	Same as Do_sqlLocalServers.
UninstallCounters	Uninstalls RBS perf counters.
UninstallEaGroups	Remove EA security groups 'SSB EA Local' and 'SSB EA Admin'.
UninstallPrivileges	Remove SeServiceLogonRight to group 'SSB EA Service' or account 'NT SERVICE\SSBExternalActivator'.
UninstallScheduledTask	Uninstalls RBS maintainer task.
ValidateAccount	Validate that account/password are of a valid windows user.
ValidateAccount.SetProperty	These methods overload the base MSI method MSiSetProperty to initialize the properties associated with the corresponding actions.
ValidatePasswordsAndAccount	Check if passwords match and account/password are of a valid windows user.
ValidateSchemaSuffix	Validates the FS provider schema suffix does not contain invalid characters.
ValidateSchemaSuffixNoUI	Schedules a deferred CA to validate the FS provider schema suffix.
ValidateSchemaSuffixNoUI.SetProperty	Sets FS provider’s schema suffix to be validated.
VSTOMISSING_64	Sets an error message to "MDSMISSINGREDISTPREREQERROR" property when VSTO runtime is not installed.
Write_HttpServiceSecurity	Schedules deferred action.
Write_NativeImage	Schedules and compiles native images of managed assemblies.
Write_NativeImage_64	Generating Native Images.
Write_sqlCopyXML	Schedules both Do and Rollback actions.
Write_sqlCopyXML_64	Schedules both Do and Rollback actions.
Write_sqlFileSDDL	Schedules deferred actions.
Write_sqlFileSDDL_64	Setting File Security.
Write_sqlFileSR	Schedules deferred actions.
Write_sqlFileSR_64	Updating Installed Files.
Write_sqlLocalServers	Schedules deferred actions (Do and Rollback).
Write_sqlLocalServers_64	Registering local servers.
Write_sqlRegHiveCopy	Schedules deferred actions (Do, Rollback, and Commit) to copy registry hives.
Write_sqlRegSDDL	Schedules deferred actions.
Write_sqlRegSDDL_64	Setting Registry Security.
Write_sqlServiceSDDL	Schedules deferred actions.
Write_sqlServiceSDDL_64	Setting Service Security.
Write_sqlServiceSidType_64	Setting Service SID Type.
Write_sqlVerIndependentProgID	Schedules deferred actions (Do only).
Write_sqlVerIndependentProgID_64	Restoring COM Servers.
Write_UpdateTypeLib	Schedules deferred actions.
Write_UpdateTypeLib_64	Registering type libraries.

See Also

Concepts

Install SQL Server 2012

SQL Server Files Left After Uninstall