Complete Image Rules

SQL Server Setup validates your computer configuration before the Setup operation completes. The following table describes check parameters for the System Configuration Checker and resolution to blocking issues.

Check item

Description

User action

AclPermissionsFacet

Checks if the SQL Server registry keys are consistent

SQL Server registry keys must be consistent to support SQL Server installation or upgrade

MediaPathLength

Checks whether the SQL Server installation media is too long.

Ensure that the SQL Server installation media path is not too long.

OsVersionCheck

Checks whether the computer meets minimum operating system version requirements.

The operating system must meet the minimum requirements for this product. For more information, see Hardware and Software Requirements for Installing SQL Server 2008 R2.

RebootRequiredCheck

Checks if a pending computer restart is required. A pending restart can cause Setup to fail.

A computer restart is required. You must restart this computer before installing SQL Server.

ThreadHasAdminPrivilegeCheck

Checks whether the account that is running SQL Server Setup has administrative privileges on the computer.

Ensure that the account running SQL Server Setup has administrative privileges on the computer.

WmiServiceStateCheck

Checks whether the WMI service is started and running on the computer.

The WMI service must be running.

FacetDomainControllerCheck

Checks whether the computer is a domain controller. Installing SQL Server on a domain controller is not recommended.

Ensure that this computer is not a domain controller.

FacetPowerShellCheck

Checks whether Windows PowerShell is installed. Windows PowerShell is a pre-requisite of SQL Server Express with Advanced Services.

For installations of SQL Server Express with Advanced Services, ensure that Windows PowerShell is installed.

FacetWOW64PlatformCheck

Determine if the setup program is supported on operating system platform.

This will block any unsupported installations on a 64-bit platform. WOW installations are not supported for SysPrep.

FusionRebootCheck

Checks if a computer restart is required because of broken fusion ATL. A pending restart can cause SQL Server Setup to fail.

A computer restart is required. You must restart the computer before installing SQL Server.

PerfMonCounterNotCorruptedCheck

Checks if the existing performance counter registry hive is consistent.

Ensure that the performance counter registry hive is consistent.

SqlUnsupportedProductBlocker

Checks whether SQL Server 7.0 or SQL Server 7.0 OLAP Services is installed. SQL Server 2008 R2 is not supported side-by-side with SQL Server 7.0.

Remove SQL Server 7.0 or install SQL Server 2008 R2 on a different computer.

SSMS_IsInternetConnected

Checks to see if the computer is connected to the Internet. SQL Server Management Tools based on .NET Framework technology must check the certificate revocation list on startup.

Ensure that the computer is connected to the Internet.

IsFirewallEnabled

Checks whether the Windows Firewall is enabled.

Make sure the fire wall is enabled and appropriate ports are open to enable remote access. For more information about ports to open for each feature, see Configuring Windows Firewall to allow SQL Server Access .

AS_ValidateEditionUpgrade

Checks whether SQL Server Analysis Services is being upgraded to the correct edition

InstanceClashRule

Checks whether the specified instance name is already used by an existing instance of SQL Server.

Use a unique instance name that is not currently used by other instances installed on the machine.

LibertyASInstallRule

Checks whether a default instance of SQL Server 2000 (64-bit) Analysis Services is installed.

Sql2005SsmsExpressFacet

Checks whether SQL Server 2005 Express Edition Tools are installed.

VSShellInstalledRule

Checks for previous releases of Visual Studio 2008 or if it has already been upgraded to SP1.

You must upgrade to Visual Studio 2008 SP1 before installing SQL Server 2008 R2.

EditionDownGradeCheck

Checks whether the edition of the selected instance of SQL Server is supported in this scenario.

Some editions are supported for upgrade. For more information, see Version and Editions Upgrades.

EditionRequirementCheck

Checks whether the SQL Server edition is supported on this operating system.

You must confirm that the SQL Server edition you are installing is supported on the operating system on this machine. For more information, see Hardware and Software Requirements for Installing SQL Server 2008 R2.

EditionUpgradeMatrixCheck

Checks whether the selected instance of SQL Server meets upgrade matrix requirements.

Some editions are supported for upgrade. For more information, see Version and Editions Upgrades.

FAT32FileSystemCheck

Checks whether the specified drive is FAT32 file system volume. Installing on a FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.

Ensure that the drive you are specifying to install SQL Server is not a FAT32 file system.