德瑞克：SQL Server 學習筆記: Install SQL Server 2017 on Windows Server 2016

2017-10-07

Install SQL Server 2017 on Windows Server 2016

版本資訊：
SQL Server 2017 RTM - 14.0.1000.169 (X64)

Build Information	Note
SQL Server Version	SQL Server 2017
Product Version	14.0.1000.169
Product Level	RTM
Product Edition	Enterprise Edition (64-bit)
Database Internal Version	869

SQL Server 2017 的圖型介面工具：SSMS、SSDT，需要額外下載安裝。

SSMS(SQL Server Management Studio)

免費下載的圖形工具，可以加以利用來存取、設定、管理及開發 SQL Server 的所有元件。
SSMS 利用許多豐富的指令碼編輯器來合併一群非常廣泛的圖形工具，使所有技術層級的開發人員及管理員都能夠存取。

SSMS 17.2, Performance Dashboard built-in, 中文版本

SSDT(SQL Server 2017 Data Tools)

Install SQL Server 2017 Data Tools (SSDT) for Visual Studio 2015

SSRS(SQL Server 2017 Reporting Services)

Install SQL Server 2017 Reporting Services (SSRS)

版本資訊

-- 001_SQL Server 2017 + Windows Server 2016

-- 002_SQL Server 2017

-- 003_資料庫相容性層級：140

-- 004_檢視伺服器屬性

Query version, edition and update level

V1: Query SQL Server system and build information

-- V1_SQL Server system and build information
/*
Applies to: SQL Server 2012：
 SERVERPROPERTY('ProductUpdateLevel') 'ProductUpdateLevel', 
 SERVERPROPERTY('ProductBuildType') 'ProductBuildType', 
 SERVERPROPERTY('ProductUpdateReference') 'ProductUpdateReference', 
*/
SELECT @@SERVERNAME 'InstanceName',
 CASE
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '8%' THEN 'SQL Server 2000'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '9%' THEN 'SQL Server 2005'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.0%' THEN 'SQL Server 2008'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.5%' THEN 'SQL Server 2008 R2'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '11%' THEN 'SQL Server 2012'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '12%' THEN 'SQL Server 2014'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '13%' THEN 'SQL Server 2016'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '14%' THEN 'SQL Server 2017'
   ELSE 'unknown'
 END AS 'SQLServerVersion ', 
  CASE
     WHEN SERVERPROPERTY('IsClustered') = 1 AND SERVERPROPERTY('IsHadrEnabled') = 1 THEN 'Failover Cluster + Availability Groups'
  WHEN SERVERPROPERTY('IsClustered') = 1 THEN 'Failover Cluster'
  WHEN SERVERPROPERTY('IsHadrEnabled') =1 THEN 'Availability Groups'
  ELSE 'unknown'
  END AS 'High-Availability',
 SERVERPROPERTY('ProductVersion') 'ProductVersion',
 SERVERPROPERTY('ProductLevel') 'ProductLevel',
 SERVERPROPERTY('Edition') 'ProductEdition',
 SERVERPROPERTY('ProductUpdateLevel') 'ProductUpdateLevel', 
 SERVERPROPERTY('ProductBuildType') 'ProductBuildType', 
 SERVERPROPERTY('ProductUpdateReference') 'ProductUpdateReference', 
 DATABASEPROPERTYEX('master','Version') 'DatabaseInternalVersion'
GO

V2: Query SQL Server system and build information

適用於 SQL Server 2017
加上作業系統平台
使用 SQL Server 2017 新增加的 sys.dm_os_host_info

-- V2_SQL Server system and build information
-- Applies to: SQL Server 2017
 
SELECT @@SERVERNAME 'InstanceName',
 CASE
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '8%' THEN 'SQL Server 2000'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '9%' THEN 'SQL Server 2005'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.0%' THEN 'SQL Server 2008'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.5%' THEN 'SQL Server 2008 R2'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '11%' THEN 'SQL Server 2012'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '12%' THEN 'SQL Server 2014'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '13%' THEN 'SQL Server 2016'
   WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '14%' THEN 'SQL Server 2017'
   ELSE 'unknown'
 END AS 'SQLServerVersion ', 
  CASE
     WHEN SERVERPROPERTY('IsClustered') = 1 AND SERVERPROPERTY('IsHadrEnabled') = 1 THEN 'Failover Cluster + Availability Groups'
  WHEN SERVERPROPERTY('IsClustered') = 1 THEN 'Failover Cluster'
  WHEN SERVERPROPERTY('IsHadrEnabled') =1 THEN 'Availability Groups'
  ELSE 'unknown'
  END AS 'High-Availability',
   host_distribution 'HostDistribution', host_release 'HostRelease',
 SERVERPROPERTY('ProductVersion') 'ProductVersion',
 SERVERPROPERTY('ProductLevel') 'ProductLevel',
 SERVERPROPERTY('Edition') 'ProductEdition',
 SERVERPROPERTY('ProductUpdateLevel') 'ProductUpdateLevel', 
 SERVERPROPERTY('ProductBuildType') 'ProductBuildType', 
 SERVERPROPERTY('ProductUpdateReference') 'ProductUpdateReference', 
 DATABASEPROPERTYEX('master','Version') 'DatabaseInternalVersion'
FROM sys.dm_os_host_info 
GO

安裝抓圖

Install SQL Server 2017 on Windows Server 2016
https://photos.app.goo.gl/5MnOMWLa5iinOjRJ2

下載 SQL Server 2017

SQL Server 2017 下載
https://www.microsoft.com/zh-tw/sql-server/sql-server-downloads