Hướng dẫn cài đặt microsoft sql server trên windows 10

Feedback will be sent to dienmayxuyena.com: By pressing the submit button, your feedback will be used to improve dienmayxuyena.com products & services. Privacy policy.

Bạn đang xem: Hướng dẫn cài đặt microsoft sql server trên windows 10

In this article

This article contains guidance about how khổng lồ use different versions of dienmayxuyena.com SQL hệ thống on a computer that is running Windows operating system.

Original hàng hóa version: SQL ServerOriginal KB number: 2681562

Summary

Note

Unless noted otherwise, when an OS is supported for a SQL Major version, it remains supported for all subsequent servicing releases. For example, if SQL Server 2016 RTM is supported on Windows 10, this implies that any CUs on vị trí cao nhất of SQL Server 2016 RTM or SQL Server 2016 Service Pack 1 (SP1) are supported on Windows 10.

How lớn use this article:

To find answers lớn the following questions, đánh giá the corresponding links under Hardware and Software Requirements page.

Which editions of SQL hệ thống are compatible with which versions of Windows?What are the .NET Framework requirements for my SQL version?

Use the More Information/Limitations column in the above table khổng lồ find additional information about running SQL hệ thống on the specific operating system.

For example, if you want to lớn install SQL Server 2016 Developer Edition on Windows 10 Professional:

Check if SQL Server năm 2016 is supported on Windows 10. The corresponding value in the above table is Yes (SP2).

Yes indicates that SQL Server năm 2016 on Windows 10 is supported.

(SP2) indicates that SQL Server năm 2016 should be updated to lớn at least SP2 for it khổng lồ be supported on Windows 10.

The Hardware và Software Requirements page for SQL 2016 confirms that SQL Server 2016 Developer edition is supported on Windows 10 Professional.

The More Information/Limitations column for Windows Server năm 2016 do not call out any additional known issues for this configuration.

Minimum SQL hệ thống version requirements for Windows server 2022 and Windows 11

This section describes the minimum version requirements khổng lồ install SQL vps on a computer that is running Windows vps 2022 or Windows 11.

Before you install SQL server on a computer that is running Windows server 2022 or Windows 11, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation.

For SQL hệ thống 2019 on Windows

The release is supported at the SQL hệ thống 2019 on Windows RTM Release version.

For SQL vps 2017 on Windows

The release is supported at the SQL hệ thống 2017 on Windows RTM Release version.

For SQL server 2016 and older versions

SQL Server 2016 and older versions are not supported on Windows server 2022 or Windows 11.

Minimum SQL vps version requirements for Windows hệ thống 2019

This section describes the minimum version requirements to lớn install SQL vps on a computer that is running Windows vps 2019.

Before you install SQL server on a computer that is running Windows server 2019 you must make sure that you fulfill the following minimum requirements, as appropriate for your situation.

For SQL vps 2019 on Windows

The release is supported at the SQL hệ thống 2019 on Windows RTM Release version.

For SQL server 2017 on Windows

The release is supported at the SQL server 2017 on Windows RTM Release version.

For SQL vps 2012

You must apply SQL hệ thống 2012 Service Pack 4 or a later update. For more information, see How to obtain the latest service pack for SQL vps 2012.

Note

Make sure that you kiểm tra known thiết lập issues when you install SQL hệ thống 2012 on Windows 10 or Windows hệ thống 2016.The Books Online topic Hardware và Software Requirements for Installing SQL hệ thống 2012 has not yet been updated to lớn reflect the tư vấn for Windows server 2016.

For SQL hệ thống 2008 R2

SQL vps 2008 R2 is not supported on Windows 10 or Windows server 2016.

For SQL hệ thống 2008

SQL server 2008 is not supported on Windows 10 or Windows server 2016.

Minimum SQL vps version requirements for Windows 10 & Windows hệ thống 2016

This section describes the minimum version requirements to install SQL hệ thống on a computer that is running Windows 10 or Windows hệ thống 2016.

Before you install SQL vps on a computer that is running Windows 10 or Windows server 2016, you must make sure that you fulfill the following minimum requirements, as appropriate for your situation.

For SQL vps 2019 on Windows

The release is supported at the SQL server 2019 on Windows RTM Release version.

For SQL server 2017 on Windows

The release is supported at the SQL hệ thống 2017 on Windows RTM Release version.

For SQL vps 2012

You must apply SQL server 2012 Service Pack 2 or a later update. For more information, see How to obtain the latest service pack for SQL vps 2012.

Note

Make sure that you kiểm tra known thiết đặt issues when you install SQL vps 2012 on Windows 10 or Windows hệ thống 2016.

The Books Online topic Hardware & Software Requirements for Installing SQL server 2012 has not yet been updated to lớn reflect the tư vấn for Windows vps 2016.

For SQL vps 2008 R2

SQL server 2008 R2 is not supported on Windows 10 or Windows vps 2016.

For SQL vps 2008

SQL vps 2008 is not supported on Windows 10 or Windows hệ thống 2016.

Minimum SQL hệ thống version requirements for Windows hệ thống 2012 R2 or Windows 8.1

This section describes the minimum version requirements for installing SQL hệ thống on a computer that is running Windows hệ thống 2012 R2 or Windows 8.1.

Xem thêm: Vtv2 Phát Lại Phim “Vịnh Xuân Quyền”, Lương Tán Nhân Vật Lịch Sử Của Vịnh Xuân

Before you install SQL hệ thống 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:

For SQL vps 2019 on Windows

SQL vps 2019 is not supported on Windows 8.1 or Windows server 2012 R2.

Also check known setup issues when you install SQL server 2008 R2 and SQL hệ thống 2008 on a computer that is running Windows server 2012 R2, Windows hệ thống 2012, Windows 8.1, or Windows 8.

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

Note

Windows 8 has reach kết thúc of support, which means Windows 8 devices no longer receive important security updates. We recommend making the free upgrade khổng lồ Windows 8.1 khổng lồ continue receiving security updates và support. For additional information nhận xét Update lớn Windows 8.1 from Windows 8.

This section describes the minimum version requirements to lớn install SQL vps on a computer that is running Windows vps 2012 or Windows 8.

Before you install SQL vps 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:

For SQL hệ thống 2019 on Windows

SQL server 2019 is not supported on Windows 8.1 or Windows hệ thống 2012 R2.

For SQL vps 2017 on Windows

The release is supported at the SQL vps 2017 on Windows RTM Release version.

For SQL hệ thống 2008

You must apply SQL hệ thống 2008 Service Pack 4 or a later update.

Note

The RTM installation of the product is supported. However, you have to lớn install the respective service packs after the initial thiết lập is complete. Your SQL server 2008 installation is not supported unless you apply Service Pack 4 after you install the RTM edition. You will see the following message on the Solution Center page.

For more information, see How khổng lồ obtain the latest service pack for SQL server 2008.

Important

The following dialog box appears in SQL hệ thống 2008 R2 and SQL server 2008 when you run the setup program.

After the SQL Server thiết đặt program is finished, you have lớn install service packs before you run SQL hệ thống on this version of Windows.

For SQL server 2008, you have khổng lồ install Service Pack 4 (SP4) or a later version.

For SQL hệ thống Compact editions

The following versions are supported in Windows 8.1, Windows 8, Windows hệ thống 2012, & Windows server 2012 R2 environments:

SQL vps Compact 3.5 Service Pack 2 and later versionsSQL vps Compact 4.0 and later versions

Support for switching modes in Windows hệ thống 2012 R2 or Windows vps 2012

This section discusses the tư vấn policy when you switch Windows vps 2012 R2 or Windows server 2012 operating modes while SQL server is installed.

Windows server 2012 R2 & Windows server 2012 have the following feature states, or modes:

Full ServerMinimal vps InterfaceServer CoreYou 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 hệ thống 2012 are installed. However, be aware that you cannot switch from Full server to Minimal vps Interface or Server chip core when one or more instances of SQL Server năm trước or SQL hệ thống 2012 are installed.

To switch from Full hệ thống to Minimal server Interface or Server vi xử lý core when one or more instances of SQL Server 2014 or SQL vps 2012 are installed, you must uninstall SQL Server năm trước or SQL server 2012, switch modes, và then reinstall SQL Server năm trước or SQL vps 2012. However, you can turn on SQL Server 2014 or SQL vps 2012 installation prerequisites in Full server mode, switch to Server bộ vi xử lý core mode, và then install SQL Server năm trước or SQL vps 2012.

Note

Minimal vps is a Server bộ vi xử lý core installation that has server Manager & other server tools installed. Therefore, the SQL Server cài đặt program performs the same installation steps in Windows server 2012 R2 Minimal hệ thống Interface mode and Windows server 2012 Minimal vps Interface mode & Server vi xử lý core mode. Additionally, you can switch between server Core và Minimal server when one or more instances of SQL Server năm trước or SQL vps 2012 are installed. This is a supported scenario.

SQL vps Reporting Services 2012 is not supported on Windows server 2012 R2 vps Core, Windows server 2012 hệ thống Core, Windows vps 2012 R2 Minimal server Interface mode, or Windows 2012 Minimal vps Interface mode. You can install SQL hệ thống Reporting Services 2012 on a hệ thống that is running Windows server 2012 in Full hệ thống mode và then switch lớn Windows server 2012 Server vi xử lý core mode. However, this configuration is not supported.

This issue does not apply to SQL vps 2008 or SQL server 2008 R2. SQL hệ thống 2008 và SQL server 2008 R2 are not supported in Minimal vps Interface mode or Server bộ vi xử lý core mode.

For more information about the installation options that are available when you install Windows vps 2012, see Windows server Installation Options.

SQL server 2012 and SQL vps 2008 R2 tư vấn for new features in Windows 8.1, Windows 8, Windows server 2012 R2, & Windows vps 2012

This section summarizes how versions of SQL vps work with some new features in Windows 8.1, Windows 8, Windows vps 2012 R2, và Windows hệ thống 2012.

The following table summarizes how versions of SQL vps work with some new features in Windows 8 và Windows hệ thống 2012.

Note

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

FeatureSQL feature or component that interacts with this new featureSQL feature that is affected or supportedMinimum version and service pack requirements for SQLExceptions or tư vấn limitationsMore information

Storage Spaces			SQL hệ thống 2008 R2 Service Pack 1 or later version, SQL vps 2012 (RTM & later versions)NOTE SQL server 2008 R2 requires Service Pack 2 on Windows 8.1 & Windows vps 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 Errors	LazyWriter	Checksum page sniffer	SQL vps 2012		When SQL hệ thống 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 cluster	High availability	Failover Clustering	SQL server 2012	25 per failover cluster when you use drive letters & up to lớn 50 if you are using SMB file chia sẻ storage
Cluster nội dung Volumes (CSV"s)				Beginning in SQL hệ thống 2014, AlwaysOn Failover Cluster Instances supports Clustered Shared Volumes (CSV) in both Windows vps 2008 R2 và Windows hệ thống 2012. For more information on CSV, see Understanding Cluster Shared Volumes in a Failover Cluster. CSVs are not supported in versions prior to lớn SQL server 2014.

SQL server 2005 information

This section provides support information about instances of SQL hệ thống 2005 in Windows 8.1 or Windows 8 environments. It also describes the options that are available for customers who are using SQL hệ thống 2005.

dienmayxuyena.com SQL hệ thống 2005 (the release version và service packs) and earlier versions of SQL vps are not supported on Windows 10, Windows vps 2016, Windows hệ thống 2012 R2, Windows vps 2012, Windows 8.1, or Windows 8. You will receive a warning in the action Center if Windows 10, 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 vps 2005. For information about how to upgrade SQL Server, see Upgrade to SQL Server.

Note

This links points to SQL vps 2014. You can use the version picker tool at the đứng đầu of the MSDN links (Other Versions) for information about other versions.

For information about the Express editions of SQL Server, go to lớn the following dienmayxuyena.com websites:

For more information about how to lớn uninstall an existing instance of SQL hệ thống 2005, see How to lớn manually uninstall an instance of SQL vps 2005 or How to: Uninstall an Existing Instance of SQL hệ thống 2005 (Setup).

Applies to

SQL hệ thống 2005 Enterprise X64 EditionSQL vps 2005 Express EditionSQL hệ thống 2005 Standard EditionSQL vps 2005 Standard X64 EditionSQL server 2005 Workgroup EditionSQL vps 2005 Developer EditionSQL vps 2005 Enterprise EditionSQL server 2008 DeveloperSQL vps 2008 EnterpriseSQL vps 2008 ExpressSQL server 2008 R2 DatacenterSQL hệ thống 2008 R2 DeveloperSQL vps 2008 R2 EnterpriseSQL vps 2008 R2 ExpressSQL vps 2008 R2 Express with Advanced ServicesSQL hệ thống 2008 R2 StandardSQL vps 2008 R2 Standard Edition for Small BusinessSQL server 2008 R2 WebSQL server 2008 R2 WorkgroupSQL vps 2008 StandardSQL hệ thống 2008 Standard Edition for Small BusinessSQL server 2008 WebSQL vps 2008 WorkgroupSQL server 2012 DeveloperSQL vps 2012 EnterpriseSQL server 2012 ExpressSQL hệ thống 2012 StandardSQL vps 2012 WebSQL vps 2012 Enterprise CoreSQL Server 2014 Business IntelligenceSQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise CoreSQL Server 2014 ExpressSQL Server 2014 StandardSQL Server 2014 WebSQL Server năm 2016 DeveloperSQL Server 2016 EnterpriseSQL Server năm 2016 Enterprise CoreSQL Server năm 2016 ExpressSQL Server 2016 StandardSQL Server 2016 WebSQL server 2017 on Windows (all editions)SQL vps 2019 on Windows