在ECS Windows Server 2012 R2上面安装单机版SQL Server 2016

 

  1. 安装SQL Server 2016的硬件以及软件要求

Component

Requirement

.NET Framework

SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.

 

For more information, recommendations, and guidance about .NET Framework 4.6 see .NET Framework Deployment Guide for Developers.

 

Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6.

Network Software

Supported operating systems for SQL Server 2016 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.

 

Note: Shared memory and VIA are not supported on failover clusters.

 

Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

 

 

 

For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.

Hard Disk

SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.

 

Disk space requirements will vary with the SQL Server 2016 components you install. For more information, see Hard Disk Space Requirements later in this topic. For information on supported storage types for data files, see Storage Types for Data Files.

Drive

A DVD drive, as appropriate, is required for installation from disc.

Monitor

SQL Server 2016 requires Super-VGA (800x600) or higher resolution monitor.

Internet

Internet functionality requires Internet access (fees may apply).

 

  1. ESC的Windows server 2012 R2 默认安装.NET4.5 版本。另外,请在控制面板->程序->程序和功能->已安装更新 里面查找是否已经安装了KB2919355, 如果没有安装,请在控制面板->系统和安全->Windows更新中进行检测安装,或者去Microsoft官网KB2919355下载。

 

注: PolyBase配置(like DRDS)要求安装Oracle JRE 7.51或者更高版本,可以到http://www.oracle.com/technetwork/java/javase/downloads/index.html进行下载,更多详细信息参考https://msdn.microsoft.com/en-us/library/mt163689.aspx。

 

  1. 打开SQL Server 2016安装介质,点击安装,选择全新SQL Server独立安装或向现有安装添加功能
  2. 输入产品秘钥
  3. 勾选“我接受许可条款”
  4. 选择需要安装的功能
  5. 填写实例名称
  6. 选择该实例作为polybase的独立实例还是scale-out的某个计算机点
  7. 设置服务账户和实例排序规则
  8. 设置实例认证方式、管理员、数据目录、TempDB目录、初始化和自动增长大小以及filstream

 

  1. 配置Distributed Replay控制器发用户及目录
  2. 单机“接受”
  3. 配置完毕,单击“安装”。
上一篇:SQL Server 死锁案例分析


下一篇:性能测试:自建数据库与RDS性能对比SQL Server案例排查分析