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 the Express Edition of SQL Server 2008 that is running on Windows 7 or on Windows Server 2008 R2, you must have at least SQL Server 2008 Service Pack 1 (SP1) installed.
Note Express Edition already includes Service Pack 1. - For all editions of SQL Server 2005 that are running on Windows 7 or 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.
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 for your situation.
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 known as a slipstreamed version).
Nonclustered installationsYou 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 on Windows 2008 R2.
For more information about hardware and software requirements for installing SQL Server 2008, visit the
Hardware and Software Requirements for Installing SQL Server 2012
(http://msdn.microsoft.com/en-us/library/ms143506.aspx)
Microsoft Developer Network (MSDN) website.
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 on Windows Server 2008 R2.
The .NET Framework
You must enable 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
Note By default, the .NET Framework 3.5 SP1 is installed in Windows 7.
Article ID: 955725 - Last Review: July 23, 2012 - Revision: 10.0
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
| kbsqlsetup kbpreinstall kbinstallation kbprerequisite kbexpertiseadvanced kbsurveynew kbinfo kbhowto KB955725 |