Article ID: 2681562 - View products that this article applies to.
Expand all | Collapse all

On This Page

Summary

This article contains guidance about how to use different versions of Microsoft SQL Server on a computer that is running one of the following operating systems: 
  • Windows Server 2012 R2 
  • Windows Server 2012 
  • Windows 8.1 
  • Windows 8
This article discusses the following topics.

Note For more information about a topic, click the link in the "More Information" section.

  • SQL Server 2005 information 

    This topic provides support information about instances of SQL Server 2005 in Windows 8 or Windows 8.1 environments and describes the options that are available for customers who are using SQL Server 2005.
  • Minimum SQL Server version requirements for Windows Server 2012 R2 or Windows 8.1 

    This topic describes the minimum version requirements for installing SQL Server on a computer that is running Windows Server 2012 R2 or Windows 8.1.
  • Minimum SQL Server version requirements for Windows Server 2012 or Windows 8 

    This topic describes the minimum version requirements for installing SQL Server on a computer that is running Windows Server 2012 or Windows 8.
  • Support for switching modes in Windows Server 2012 R2 or Windows Server 2012

    This topic covers the support policy when you switch Windows Server 2012 R2 or Windows Server 2012 operating modes while SQL Server is installed.
  • Known Microsoft SQL Server 2012 setup and migration issues

    This topic discusses setup and migration issues that are specific to SQL Server 2012.
  • Known Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2008 setup issues

    This topic discusses setup and migration issues that are specific to SQL Server 2008 R2 and SQL Server 2008 on a computer that is running Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8.
  • SQL Server support for new features in Windows Server 2012 R2, Windows Server 2012, Windows 8.1, and Windows 8 

    This topic summarizes how versions of SQL Server work with some new features in Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012.
  • How to enable the Microsoft .NET Framework 3.5 in Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012 

    This topic discusses the following:
    • How to turn on the .NET Framework 3.5 in Windows 8 and Windows 8.1
    • How to add roles and features in Windows Server 2012 R2 and Windows Server 2012
  • SharePoint integrated mode for SQL Server Reporting Services 

     This topic discusses what to consider when you configure SQL Server in SharePoint integrated mode.

More information

SQL Server 2005 information

Collapse this imageExpand this image
assets folding start collapsed
SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 8.1 or Windows 8 detects an instance of SQL Server 2005.

To resolve this issue, upgrade or remove the existing instance of SQL Server 2005. For information about how to upgrade SQL Server, go to the following Microsoft Developer Network (MSDN) website: 

http://msdn.microsoft.com/en-us/library/bb677622.aspx

Note This link points to SQL Server 2012. You can use the version picker tool at the top of the MSDN link (Other Versions) for information about other versions. 

For information about the Express editions of SQL Server, go to the following Microsoft websites:

SQL Server 2012 Service Pack 1 (SP1) Express Edition

SQL Server 2008 R2 Service Pack 2 (SP2) Express Edition

SQL Server 2008 Express Edition

Note You must manually install Service Pack 3 after you install SQL Server 2008 Express Edition.

For information about how to uninstall an existing instance of SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:
909967 How to manually uninstall an instance of SQL Server 2005
For more information about how to uninstall an existing instance of SQL Server 2005, go to the following MSDN website:

http://msdn.microsoft.com/en-us/library/ms143412(v=SQL.90).aspx
Collapse this imageExpand this image
assets folding end collapsed

Minimum SQL Server version requirements for Windows Server 2012 R2 or Windows 8.1

Collapse this imageExpand this image
assets folding start collapsed
Before you install SQL Server on a computer that is running Windows Server 2012 R2 or Windows 8,1 you must make sure that you fulfill the following minimum requirements, as appropriate for your situation:

SQL Server 2014

Collapse this imageExpand this image
assets folding start collapsed
You can install the release version of SQL Server 2014 or a later version.
For more information, check out the SQL Server 2014 main page.
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2012

Collapse this imageExpand this image
assets folding start collapsed
You must apply SQL Server 2012 Service Pack 1 or a later update. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012
Note Please check known setup issues when you install SQL Server 2012 on Windows 8 or Windows Server 2012. A description of these issues appears later in this article.
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2008 R2

Collapse this imageExpand this image
assets folding start collapsed
You must apply SQL Server 2008 R2 Service Pack 2 or a later update. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041 How to obtain the latest service pack for SQL Server 2008 R2
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2008

Collapse this imageExpand this image
assets folding start collapsed
You must apply SQL Server 2008 Service Pack 3 or a later update.

Note The RTM installation of the product is supported. But you have to install the respective service packs after the initial setup is complete. Your SQL Server 2008 installation is not supported unless you apply Service Pack 3 after you install the RTM edition.  

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008
Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end collapsed

Minimum SQL Server version requirements for Windows Server 2012 or Windows 8

Collapse this imageExpand this image
assets folding start collapsed
Before you install SQL Server on a computer that is running Windows Server 2012 or Windows 8, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation:

SQL Server 2014

Collapse this imageExpand this image
assets folding start collapsed
You can install the release version of SQL Server 2014 or a later version.
For more information, check out the SQL Server 2014 main page.
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2012

Collapse this imageExpand this image
assets folding start collapsed
You can install the release version of SQL Server 2012 or a later version.

Note Please check known setup issues when you install SQL Server 2012 on Windows 8 or Windows Server 2012
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2008 R2

Collapse this imageExpand this image
assets folding start collapsed
You must apply Microsoft SQL Server 2008 R2 Service Pack 1 or a later update.

Note The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. You will see the following message on the Solution Center page:

Collapse this imageExpand this image
A screen shot showing the Solution Center page


For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041 How to obtain the latest service pack for SQL Server 2008 R2
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2008

Collapse this imageExpand this image
assets folding start collapsed
You must apply SQL Server 2008 Service Pack 3 or a later update.

Note The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. Your SQL server 2008 installation is not supported unless you apply Service Pack 3 after you install the RTM edition. You will see the following message on the Solution Center page:

Collapse this imageExpand this image
A screen shot showing the Solution Center page


For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008

Note The following dialog box appears in SQL Server 2008 R2 and SQL Server 2008 when you run the Setup program:

Collapse this imageExpand this image
A screen shot showing a dialog box that appears in SQL Server 2008 R2 and SQL Server 2008 when running the Setup program



After the SQL Server Setup program is finished, you have to install service packs before you run SQL Server on this version of Windows. For SQL Server 2008, you have to install Service Pack 3 (SP3) or a later version. For SQL Server 2008 R2, you have to install Service Pack 1 (SP1) or a later version.
Collapse this imageExpand this image
assets folding end collapsed

SQL Server Compact editions

Collapse this imageExpand this image
assets folding start collapsed
The following versions are supported in Windows 8.1, Windows 8, Windows Server 2012, and Windows 2012 environments:
  • SQL Server Compact 3.5 Service Pack 2 and later versions  
  • SQL Server Compact 4.0 and later versions

    Note No support is planned for Windows RT devices.
Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end collapsed

Support for switching modes in Windows Server 2012 R2 or Windows Server 2012

Collapse this imageExpand this image
assets folding start collapsed

Windows Server 2012 R2 and Windows Server 2012 have three feature states, or modes:
  • Full Server
  • Minimal Server Interface
  • Server Core
You can switch between these feature states at any time. You can switch from Server Core or Minimal Server Interface to Full Server when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. However, be aware that you cannot switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. 

To switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed, you must uninstall SQL Server 2014 or SQL Server 2012, switch modes, and then reinstall SQL Server 2014 or SQL Server 2012. However, you can turn on SQL Server 2014 or SQL Server 2012 installation prerequisites in Full Server mode, switch to Server Core mode, and then install SQL Server 2014 or SQL Server 2012.

Note Minimal Server is a Server Core installation that has Server Manager and other server tools installed. Therefore, the SQL Server Setup program performs the same installation steps in Windows Server 2012 R2 Minimal Server Interface mode and Windows Server 2012 Minimal Server Interface mode and Server Core mode. Additionally, you can switch between Server Core and Minimal Server when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. This is a supported scenario.

Note SQL Server Reporting Services 2012 is not supported on Windows Server 2012 R2 Server Core, Windows Server 2012 Server Core, Windows Server 2012 R2 Minimal Server Interface mode, or Windows 2012 Minimal Server Interface mode. You can install SQL Server Reporting Services 2012 on a server that is running Windows Server 2012 in Full Server mode and then switch to Windows Server 2012 Server Core mode. However, this configuration is not supported.

Note We recommend that you uninstall all the SQL Server 2012 features that are not supported on a server that is running Windows Server 2012 R2 or Windows Server 2012 in Server Core mode. For information about how to do this, go to the following MSDN website:

http://msdn.microsoft.com/en-us/library/hh231669.aspx

Note This issue does not apply to SQL Server 2008 or SQL Server 2008 R2. SQL Server 2008 and SQL Server 2008 R2 are not supported in Minimal Server Interface mode or Server Core mode.

For more information about the installation options that are available when you install Windows Server 2012, go to the following Microsoft TechNet website:

http://technet.microsoft.com/en-us/library/hh831786
Collapse this imageExpand this image
assets folding end collapsed

Known SQL Server 2012 setup and migration issues


Collapse this imageExpand this image
assets folding start collapsed
General notes

Note for SQL Server 2014 installations The items under "General Notes" also apply to SQL Server 2014 installations. However, SQL Server 2014 setup will not let you continue if any components that require the Microsoft .NET 3.5 Framework are selected and the .NET 3.5 Framework is not installed.
  • By default, Windows 8 includes the .NET Framework 4.0. Windows 8.1 and Windows Server 2012 R2 include the .NET Framework 4.5. However, the following SQL Server 2012 components depend on the .NET Framework 3.5:
    • SQL Server 2012 Database Engine
    • Replication Service
    • SQL Server Data Tools
    • Data Quality Service
    • Master Data Service
    • Reporting Service Native Mode
    • Full-Text Search


    Therefore, we recommend that you enable the .NET 3.5 Framework before you install SQL Server 2014 or SQL Server 2012 in a stand-alone or clustered environment to help prevent any possible SQL Server setup failures.

    Note For information about how to enable the .NET 3.5 Framework, see "How to enable the .NET 3.5 Framework in Windows 8" section in this article.
Some SQL Server 2012 installation and setup issues are fixed in the latest cumulative updates for SQL Server 2012. Therefore, we recommend that you create a slipstream installation package that includes SQL Server 2012 and CU3 or a later update. For information about how to do this, see the following MSDN website:
http://blogs.msdn.com/b/jason_howell/archive/2012/08/28/how-to-patch-sql-server-2012-setup-with-an-updated-setup-package-using-updatesource-to-get-a-smart-setup.aspx

SQL Server 2012 setup issues that can occur when the .Net Framework 3.5 is not enabled

Collapse this imageExpand this image
assets folding start collapsed
Issue 1 - Incomplete SQL Failover Cluster or Stand-alone installations

On servers where the .NET Framework 3.5 is not already installed or servers where Internet access is restricted, the SQL Server 2012 installation program does not install components that depend on the .NET Framework 3.5. Therefore, the SQL Server 2012 installation may be incomplete.

Note Windows 8.1 or Windows Server 2012 R2 will not let you continue with the installation.

Note For a list of SQL Server 2012 components that depend on the .NET Framework 3.5, see the "Known SQL Server 2012 setup and migration issues" topic.

An error message that resembles the following may be displayed during SQL Server 2012 installation when the .NET Framework is not enabled:

Collapse this imageExpand this image
A screen shot showing an error message


Prevention

To prevent this issue, enable the .NET Framework 3.5 on all nodes of the cluster or on the stand-alone server before you install SQL Server 2012.

Resolution

To resolve this issue on a stand-alone server, enable the .NET Framework 3.5, and then run Setup again to add the additional features.

To resolve this issue in a clustered environment, uninstall the incomplete SQL Server 2012 instances, enable the .NET Framework 3.5, and then reinstall SQL Server 2012.

Note In a clustered environment, you cannot add the features that were skipped by running SQL Server 2012 Setup again.

To resolve this issue on a stand-alone server, enable the .NET Framework 3.5, and then run SQL Server Setup again.


Issue 2 - Users incorrectly are prompted to download and install the .NET Framework 3.5

Users incorrectly may be prompted to download and install the .NET Framework 3.5 when they try to install CU1 or CU2. This issue can occur even though the installed components do not depend on the .NET Framework 3.5. 

Users may receive an error message that resembles the following:

Collapse this imageExpand this image
A screen shot showing an error message


Cause

This is a known issue in SQL Server 2012 CU1 and CU2.

Note This issue is fixed in Cumulative Update 3 for SQL Server 2012 and later versions.

Prevention

To prevent this issue, we recommend that you do one of the following:
  • Enable the .NET Framework 3.5, apply the CU1 update package or the CU2 update package, and then disable the .NET Framework 3.5.

    Note You should only disable the .NET Framework 3.5 if your installation does not include components that depend on the .NET Framework 3.5.
  • Install SQL Server 2012 from a slipstreamed installation package that includes SQL Server 2012 and CU3 or a later version.
  • Apply Cumulative Update 3 or a later version. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    2692828 The SQL Server 2012 builds that were released after SQL Server 2012 was released

Issue 3 - Windows application compatibility mode alerts are displayed during a silent install

In Windows 8.1, Windows 8, Windows Server 2012 R2 and Windows Server 2012, the .NET Framework is a Feature-On-Demand (FOD) component. Additionally, the Windows 8.1 and Windows 8 system policies and the Windows Server 2012 R2 and Windows Server 2012 system policies require users to be alerted when FOD components are enabled. 

Note By default, the .NET Framework 4.0 is enabled in Windows 8 and Windows Server 2012. Additionally, the .NET Framework 4.5 is enabled in Windows 8.1 and Windows Server 2012 R2. However, the .NET Framework 3.5 is disabled.

Therefore, a program compatibility mode warning that prompts users to download and install the .NET Framework 3.5 may be displayed during a silent install:

Note These program compatibility alerts cannot be suppressed. Screen shots of warnings are shown here:

Windows Server 2012 R2 and Windows Server 2012 - Full Server

Collapse this imageExpand this image
A screen shot showing alerts for Windows Server 2012 - Full Server


Windows Server 2012 R2 and Windows Server 2012 - Server Core

Collapse this imageExpand this image
A screen shot showing alerts for Windows Server 2012 - Server Core


To prevent this issue, the user can enable the .NET Framework 3.5 before they perform a silent installation.
Collapse this imageExpand this image
assets folding end collapsed

Additional SQL Server 2012 setup issues

Collapse this imageExpand this image
assets folding start collapsed
Issue 1 - A .NET Framework unhandled exception may be generated when you try to install a second instance of SQL Server 2012

Consider the following scenario:
  • You install an instance of SQL Server 2012.
  • A .NET Framework 4.0 user configuration file is created when you install the instance of SQL Server 2012. Additionally, the .NET Framework 3.5 is enabled during the installation.
  • You try to install a second instance of SQL Server 2012.
In this scenario, an unhandled exception may be generated. You may receive an error message that resembles the following:

An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=xxxxx’ or one of its dependencies. The system cannot find the file specified. (C:\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0\user.config)

This error message resembles the following:

Collapse this imageExpand this image
A screen shot showing the error message



In Windows 8 and Windows Server 2012, this issue occurs because the .NET Framework 4.0 is enabled by default in Windows 8 and Windows Server 2012. Therefore, a .NET Framework 4.0 user configuration file is created when you install SQL Server 2012. Additionally, the .NET Framework 3.5 is enabled during the installation.

When you try to install the second instance of SQL Server 2012, the installation uses the .NET Framework 2.0 because the .NET Framework 3.5 is already installed. This conflicts with the setting in the user configuration file and causes the unhandled exception.

In Windows 8.1 and Windows Server 2012 R2, this issue occurs because the .NET Framework 4.5 is enabled by default in Windows 8.1 and Windows Server 2012 R2. Therefore, a .NET Framework 4.5 user configuration file is created when you install SQL Server 2012. Additionally, the .NET Framework 3.5 is enabled during the installation.

When you try to install the second instance of SQL Server 2012, the installation uses the .NET Framework 2.0 because the .NET Framework 3.5 is already installed. This conflict with the setting in the user configuration causes the unhandled exception.

To prevent this issue, delete the User.config file in the following folder before you install the second instance of SQL Server 2012:
%userprofile%\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0

Resolution

Note This issue is fixed in Microsoft SQL Server 2012 Service Pack 1 (SP1).

f the first instance already has Service Pack 1 installed you should not experience this issue. If you cannot install Service Pack 1 on the first instance, do one of the following and then install SQL Server 2012:
  • Install the second SQL Server 2012 instance from a slipstreamed installation package that includes SQL Server 2012 and Microsoft SQL Server 2012 Service Pack 1 or a later version.
  • Pre-patch by using the SQL Server 2012 SP1 files:
    • On a computer where SQL Server 2012 RTM is not installed:
      1. Download and install SQL Server 2012 SP1.
      2. On the License Terms screen, click the I accept the license terms check box and then click Next.
        Note The setup files are installed and the installation wizard automatically close.
      3. Verify the installation. To do this, start Add or Remove Programs and verify that the following are listed:
        • Microsoft SQL Server 2012 Setup, version 11.1.3000.0
        • Two entries for Microsoft Visual C++.
    • On a computer that has an existing instance of SQL Server 2012 RTM:
      1. Download and install SQL Server 2012 SP1.
      2. Extract the SP1 files to a local folder. For example, extract the SP1 files to c:\sp1.
        Note You cannot run SQL Server 2012 SP1 setup in this scenario.
      3. In the folder that you extracted the SP1 files to, double-click SqlSupport.msi and then click Yes.
      4. Verify the installation. To do this, start Add or Remove Programs and verify that Microsoft SQL Server 2012 Setup, version 11.1.3000.0 is listed.
       
    Note Check the "Installation Instructions" section on the SQL Server 2012 SP1 download page to determine the correct download for your server.

Issue 2 - You cannot install a SQL Server 2012 Failover Cluster with the File Stream Share feature enabled on Windows Server 2012 R2 or Windows Server 2012

You may receive an error message that resembles the following when you try to install a new SQL Server 2012 Failover Cluster with the FileStream Share feature enabled on Windows Server 2012:
There was an error setting private property 'Security0x20Descriptor' to value 'System.Byte[]' for resource 'SQL Server Filestream share (FILESTREAM)'. Error: There was a failure to call cluster code from a provider. Exception message: Not found.

Cause

This issue occurs because support for the Security Descriptor property was dropped in Windows Server 2012.

Prevention

To prevent this issue, install the failover cluster without the FileStream Share feature enabled. After the installation is complete, enable the FileStream Share feature.

Resolution

To resolve this issue, uninstall the failed cluster instance by using Add or Remove Programs, and then install the failover cluster without the FileStream Share feature enabled. After the installation is complete, enable the FileStream Share feature.

Note This issue is fixed in Microsoft SQL Server 2012 Service Pack 1 (SP1).

Issue 3 - Error during SQL Server 2012 installation: "An attempt was made to load a program with an incorrect format"

Consider the following scenario:
  • You install a 64-bit version of Windows 8.1 or Windows 8.
  • You try to install SQL Server 2012 in Windows-on-Windows (WoW) mode.
  • The SQL Server 2012 installation includes Reporting Services.
In this scenario, the installation fails. Additionally, you receive an error message that resembles the following:

Operation failed with 0x8007000B

An attempt was made to load a program with an incorrect format

Collapse this imageExpand this image
A screen shot showing the error message


To prevent this issue, install the IIS ASP.NET 3.5 component by using Server Manager before you install SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2748719 ASP.NET 2.0 and ASP.NET 3.5 do not work after you uninstall ASP.NET 4.5 in Windows 8 or Windows Server 2012


Issue 4: You cannot install a SQL Server 2012 Enterprise Edition failover cluster instance

Consider the following scenario:
  • You do one of the following:
    • You create a slipstreamed installation package that includes SQL Server 2012 and CU1.
    • You pre-patch by using CU1 before you install SQL Server 2012.
  • You install SQL Server 2012 by using the UIMODE=EnableUIOnServerCore option.
In this scenario, the installation fails. You receive an error message that resembles the following:

Collapse this imageExpand this image
A screen shot showing the error message



The details of the error resemble the following:

Collapse this imageExpand this image
A screen shot showing details of the errors



Cause

This issue occurs because the DQ feature is implicitly selected together with the Engine component during the installation.

Note The DQ feature is not supported in Server Core mode.

Note The issue is fixed in SQL Server 2012 RTM CU3 and SQL Server 2012 Service Pack 1.

Resolution

To resolve this issue, do one of the following:
  • Create a slipstreamed installation package that includes SQL Server 2012 and CU3.
  • Pre-patch the setup support files by running CU3 installation package,

Issue 5: Error message when you try to upgrade the cluster node to SQL Server 2012: ”The common properties for resource 'SQL Network Name (<SQL Name>)' could not be saved"

For more information about this issue and how to resolve it, click the article number to view the article in the Microsoft Knowledge Base:

2782511 "The common properties for resource 'SQL Network Name (<SQL Name>)' could not be saved" error when you try to upgrade the cluster node to SQL Server 2012


Issue 6: Error message when you use the OpenSQLFileStream API: "System.ComponentModel.Win32Exception (0x80004005): The request is not supported."

Consider the following scenario:
  • You install an instance of SQL Server 2008 R2 on a server that is running Windows Server 2012.
  • You upgrade the instance of SQL Server 2008 R2 to SQL Server 2012 Service Pack 1 (SP1).
  • You use the OpenSQLFileStream API.
In this scenario, you receive an error message that resembles the following:

System.ComponentModel.Win32Exception (0x80004005): The request is not supported.

Cause

This issue occurs because the SQL Server 2012 upgrade incorrectly deletes the following registry key:

HKEY_LOCALMACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList\FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT

Workaround

To work around this issue, use Registry Editor to re-create the following registry key:

HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList

Dword: FSCTL_SQL_FILESTREAM_FETCH_OLD_CONTENT
Value: 0x92560

Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end collapsed

Known SQL Server 2008 R2 and SQL Server 2008 setup issues

Collapse this imageExpand this image
assets folding start collapsed

Issue 1 - You cannot uninstall SQL Server 2008 Express Edition or SQL Server 2008 R2 Express Edition

You may receive an error message that resembles the following when you try to uninstall SQL Server 2008 R2 or Microsoft SQL Server 2008 Express Edition:

The following feature couldn’t be installed:

.NET Framework 3.5 (includes .NET 2.0 and 3.0)


Collapse this imageExpand this image
A screens shot showing the error message



Resolution

For information about how to resolve this issue, click the article number to view the article in the Microsoft Knowledge Base:
2861939 Cannot uninstall, repair, add new features to, or add a new instance to SQL Server 2008 or SQL Server 2008 R2 in Windows 8

Workaround

To work around this issue, do one of the following:
  • Enable the .Net Framework 3.5 before you uninstall SQL Server 2008 Express Edition.
  • Copy the MediaInfo.xml file from the SQL Server 2008 R2 installation media or the SQL Server 2008 Express Edition installation media to the following folder before you try to uninstall SQL Server 2008 R2 or SQL Server 2008 Express Edition:
    \Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

Issue 2 - The "Cluster Service verification" rule fails when you try to install a SQL Server 2008 R2 failover cluster instance

When you try to install a SQL Server 2008 R2 failover cluster instance, the installation fails at the "Cluster Service verification" Rule. When you view the details, you receive an error message that resembles the following:

Collapse this imageExpand this image
A screen shot showing the error message



Cause

This issue occurs if the COM-based MSClus.dll library is not enabled.

Note SQL Server 2008 and SQL Server 2008 R2 cluster Setup programs depend on the COM-based MSClus.dll library. If this library is not enabled on the cluster node, the Setup fails.

Resolution

To resolve this issue, do one of the following:
  • Enable the Failover Cluster Automation Server feature on each node by using Server Manager. In Server Manager, expand Remote Server Administration Tools, expand Feature Administration Tools, expand Failover Clustering Tools, and then click to select Failover Cluster Automation Server. (The screen shot for this step follows.)

    Collapse this imageExpand this image
    The screen shot for this step
  • Run the following Windows PowerShell cmdlet on each node to enable the Failover Cluster Automation Server feature:

    add-windowsfeature RSAT-Clustering-AutomationServer 
    Note You must run this cmdlet from an elevated command prompt.
Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end collapsed

SQL Server 2012 and SQL Server 2008 R2 support for new features in Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012 

Collapse this imageExpand this image
assets folding start collapsed
The following table summarizes how versions of SQL Server work with some new features in Windows 8 and Windows Server 2012:

Note Unless noted in the following table, all features of Windows Server 2012 are supported in all the supported versions of SQL server.


Collapse this tableExpand this table
FeatureSQL feature or component that interacts with this new featureSQL feature that is affected or supportedMinimum version and service pack requirements for SQLExceptions or support limitationsMore information
Storage SpacesSQL Server 2008 R2 Service Pack 1 or later version, SQL Server 2012 (RTM and later versions)

Note SQL Server 2008 R2 requires Service Pack 2 on Windows 8.1 and Windows Server 2012 R2.
This feature is supported with the service packs that are specified for the respective versions.
Resilient File System (ReFS)ReFS is not supported in SQL 2012 and all other down-level versions. SQL Server 2014 supports ReFS.
Mitigation of RAM Hardware ErrorsLazyWriterChecksum page snifferSQL Server 2012 When SQL Server 2012 is installed on a Windows 2012 operating system with hardware that supports bad memory diagnostics, you will notice new error messages like 854, 855, and 856 instead of the 832 errors that LazyWriter usually generates.
Number of instances per clusterHigh availabilityFailover ClusteringSQL Server 201225 per failover cluster when you use drive letters and up to 50 if you are using SMB file share storage
Cluster Share Volumes (CSV's)Beginning in SQL Server 2014, AlwaysOn Failover Cluster Instances supports Clustered Shared Volumes (CSV) in both Windows Server 2008 R2 and Windows Server 2012. For more information on CSV, see Understanding Cluster Shared Volumes in a Failover Cluster. CSVs are not supported in versions prior to SQL Server 2014.
Collapse this imageExpand this image
assets folding end collapsed

How to enable the .Net Framework 3.5 in Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012  

Collapse this imageExpand this image
assets folding start collapsed
The following prerequisites are required to enable the .Net Framework 3.5 in Windows 8 and Windows Server 2012:
  • An Internet connection for access to Windows Update.

    Note For more information about how enable the .NET Framework 3.5 if you do not have an Internet connection, see the following TechNet website:
    http://msdn.microsoft.com/library/windows/hardware/hh975396


    Note If the computer that you want to update is behind a firewall or uses a proxy server, click the following article number to view the article in the Microsoft Knowledge Base:
    900935 How the Windows Update client determines which proxy server to use to connect to the Windows Update website
  • The current user must be a member of the local Administrators group to add or remove Windows features.

How to enable the .NET Framework 3.5 by using Control Panel in Windows 8.1 and Windows 8

Collapse this imageExpand this image
assets folding start collapsed
You can use Control Panel in Windows 8 to enable the .NET Framework 3.5. The following prerequisites are required to enable the .NET Framework in Windows 8:

To enable the .NET Framework 3.5 in Windows 8, follow these steps:
  1. On the Start Screen type turn on windows features, click Settings, and then click Turn Windows features on or off. (The screen shot for this step follows.)

    Collapse this imageExpand this image
    The screen shot for this step

  2. Under Turn Windows features on or off, click .Net Framework 3.5 (includes .NET 2.0 and 3.0).

    Note The wizard will search for required files and then prompt you to download the files from Windows Update.
  3. Click Download files from Windows Update.
  4. Click Finish. (The screen shot for this step follows.)
Collapse this imageExpand this image
The screen shot for this step


Collapse this imageExpand this image
assets folding end collapsed

How to enable the .NET Framework 3.5 by using the Add Roles and Features Wizard in Windows Server 2012 R2 and Windows Server 2012

Collapse this imageExpand this image
assets folding start collapsed
To enable the .NET Framework 3.5 in Windows Server 2012 or Windows Server 2012 R2, follow these steps:
  1. In Server Manager, click Manage, and then click Add Roles and Features. (The screen shot for this step follows.)

    Collapse this imageExpand this image
    The screen shot for this step

  2. On the Before you begin screen, click Next.
  3. On the Select installation type screen, click Role-based or feature-based installation and then click Next.
  4. On the Select destination server screen, select the target server, and then click Next.
  5. On the Select server roles screen, click Next.
  6. On the Select features screen, click to select the .NET Framework 3.5 Features check box, and then click Next.
  7. Close the warning, and then click Install.

    If the computer does not have an Internet connection, click Specify an alternate source path, type the path of the \sources\SxS folder on the installation media, and then click OK. Close the warning, and then click Install. (The screen shot for this step follows.)

    Collapse this imageExpand this image
    The screen shot for this step


    Note In the screen shot, notice the statement that the .NET Framework 3.5 is not part of a typical installation. However, the installation files are available in a side-by-side store folder. Additionally, you do not have to mount or point to a specific WIM source.

Note
If you are using Server Manager in Windows Server 2012 to add a role or feature to a remote server, the computer account on the remote server requires access to the alternate source file path because the deployment operation runs in the SYSTEM context on the target server.
Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end collapsed

SharePoint integrated mode for SQL Server Reporting Services

Collapse this imageExpand this image
assets folding start collapsed
For information about how to plan what to consider when you configure SQL Server in SharePoint integrated mode, click the following article number to view the article in the Microsoft Knowledge Base:
2724471 Windows Server 2012 does not support SharePoint Server 2010
Collapse this imageExpand this image
assets folding end collapsed

System Center Advisor rule information

Collapse this imageExpand this image
assets folding start collapsed

Collapse this tableExpand this table
Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated
System Center AdvisorSQL Server Database Files resides in an unsupported FileSystemIn this SQL Server instance advisor detected the presence of one or more database files residing under ReFS (Resilient File System) in Windows Server 2012 R2 and Windows Server 2012. Hosting databases on Windows Server 2012 R2 and Windows Server 2012 ReFS file systems is not supported for production use. Review the list of Databases provided below and takes corrective actions. Refer to the KB article for more details.SQL Server 2008
SQL Server 2008 R2
SQL Server 2012

Collapse this imageExpand this image
assets folding end collapsed

References

For more information about how to deploy the .NET Framework 3.5, go to the following MSDN website:
http://msdn.microsoft.com/library/windows/hardware/hh975396

For information about how to use ASP.NET 3.5 and ASP.NET 4.5 in IIS 8.0, go to the following IIS website:
http://www.iis.net/learn/get-started/whats-new-in-iis-8/iis-80-using-aspnet-35-and-aspnet-45

For information about issues that can occur after you install ASP.NET 4.5, click the following article number to view the article in the Microsoft Knowledge Base:
2748719 ASP.NET 2.0 and ASP.NET 3.5 do not work after you uninstall ASP.NET 4.5 in Windows 8 or Windows Server 2012

For more information about new features in Windows Server 2012, go to the following TechNet website:
http://technet.microsoft.com/en-us/library/hh831769.aspx

For more information about how to install fail over clustering in Windows Server 2012, go to the following MSDN website:
http://blogs.msdn.com/b/clustering/archive/2012/04/06/10291601.aspx

Properties

Article ID: 2681562 - Last Review: July 17, 2014 - Revision: 21.0
Applies to
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2014 Business Intelligence
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Enterprise Core
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
Keywords: 
kbtshoot kbsurveynew kbinfo KB2681562

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com