Article ID: 955725 - Last Review: October 14, 2009 - Revision: 5.0

List of known issues when you install SQL Server on Windows 7 or on Windows Server 2008 R2

On This Page

Expand all | Collapse all

INTRODUCTION

This article describes the known issues when you install Microsoft SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2.

Notes
  • For all editions except express edition of SQL Server 2008 running on Windows 7 and on Windows Server 2008 R2, you must have at least SQL Server 2008 Service Pack 1 (SP1) installed. Express edition already includes Service Pack 1.
  • For all editions of SQL Server 2005 running on Windows 7 and on Windows Server 2008 R2 , you must have at least SQL Server 2005 Service Pack 3 (SP3) installed.
  • In this article, Windows 7 indicates the client version of Windows 7. Windows Server 2008 R2 indicates the server version of Windows 7.

Known issues

  • Windows 7 does not use the RequireKerberos property to determine whether Kerberos authentication is enabled

    Because Windows 7 does not use the RequireKerberos property to determine whether Kerberos authentication is enabled for a Network Name resource, Failover Cluster installation of SQL Server 2008 RTM fails.
  • When FIPS policy is enabled in Windows 7 or in Windows Server 2008 R2, Cluster Validation fails during SQL Server 2008 RTM installation

    When FIPS policy is enabled in Windows 7 or in Windows Server 2008 R2, Cluster Validation fails during the installation of SQL Server 2008 RTM. Therefore, the setup fails.

    To resolve these two problems, you must install SQL Server 2008 together with SQL Server 2008 (SP1) or a later update for clustered installations. For more information about how to obtain Microsoft SQL Server 2008 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
    968382  (http://support.microsoft.com/kb/968382/ ) How to obtain the latest service pack for SQL Server 2008
    For more informationhow to update SQL Server Setup in either a clustered or a nonclustered environment, click the following article number to view the article in the Microsoft Knowledge Base:
    955392  (http://support.microsoft.com/kb/955392/ ) How to update or slipstream an installation of SQL Server 2008
  • SQL Server 2008 RTM installation may fail on Windows Server 2008 R2

    The SQL Server 2008 RTM installation may fail on Windows Server 2008 R2 if the .NET Framework is not enabled. This problem occurs because installation of the .NET Framework 3.5 is a prerequisite to this installation.

    On Windows Server 2008 R2, the .NET Framework 3.5 is included as a Windows component, and is not installed by default. To avoid this installation failure, you must turn on the .NET Framework 3.5 from the Windows Features before you run the SQL Server 2008 RTM installation.

MORE INFORMATION

Minimum version requirements for Windows 7 or for Windows Server 2008 R2

Before you install SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2 , you must make sure that you fulfill the following minimum prerequisites, as appropriate.

SQL Server 2008


Clustered installations:
You must install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update (this is also referred to as slipstreamed version).

Non clustered installations:
You must install SQL Server 2008 followed by SQL Server 2008 Service Pack 1 or a later update.
Note SQL Server 2008 express runtime is supported on Windows 7 and Windows 2008 R2.
For more information about hardware and software requirements for installing SQL Server 2008, visit the following MSDN Web site:
http://msdn.microsoft.com/en-us/library/ms143506.aspx (http://msdn.microsoft.com/en-us/library/ms143506.aspx)

SQL Server 2005

You must install SQL Server 2005 followed by SQL Server Service Pack 3 or a later update.

For more information about clustered installations of SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:
973993  (http://support.microsoft.com/kb/973993/ ) Some nodes are not updated as expected when you apply Service Pack 3 or a post-Service Pack 3 update in a SQL Server 2005 cluster that is based on Windows Server 2008 R2 failover clustering
For more information about how to obtain SQL Server 2005 service packs, click the following article number to view the article in the Microsoft Knowledge Base:
913089  (http://support.microsoft.com/kb/913089/ ) How to obtain the latest service pack for SQL Server 2005

More information for SQL Server 2005

Note: SQL Server 2005 Express Service Pack 2 runtime is supported on Windows 7 and Windows Server 2008 R2.

The .NET Framework

You must install the Microsoft .NET Framework 3.5 SP1 before you install SQL Server 2008 on a computer that is running Windows Server 2008 R2. The .NET Framework 3.5 SP1 is a prerequisite for SQL Server 2008. SQL Server 2008 Setup will install the .NET Framework 3.5 SP1 if it is not already installed. However, for Failover Clustering, the .NET Framework 3.5 SP1 must be installed before the SQL Server 2008 Failover Cluster installation.

In Windows Server 2008 R2, the .NET Framework is a system component. Therefore, you cannot install the .NET Framework from a redistribution point. You must install the .NET Framework from the Server role or by using ServerManagerCmd.exe.

You do not have to install the .NET Framework in the following scenarios:
  • On a computer that is running Windows Server 2008 R2 and on which the .NET Framework 3.5 SP1 is installed
  • On a computer that is running Windows 7 (because the .NET Framework 3.5 SP1 is installed by default)

APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition, when used with:
    • Windows Server 2008 R2 Datacenter
    • Windows Server 2008 R2 Enterprise
    • Windows Server 2008 R2 Standard
    • Windows Web Server 2008 R2
    • Windows 7 Enterprise
    • Windows 7 Professional
    • Windows 7 Ultimate
Keywords: 
kbpreinstall kbinstallation kbprerequisite kbexpertiseadvanced kbsurveynew kbinfo kbhowto KB955725
 

Article Translations

 

Related Support Centers