SRE文档

深浅模式

1. 安装系统 ​

1.1 winserver2016 ​

禁止更新 ​

（1）WinServer2016禁止自动更新

管理员运行cmd

输入sconfig

选择5，选择m

image-20240614150226441

（2）禁止更新后自动重启方法

进入系统工具→任务计划程序→任务计划程序库→Microsoft→Windows→UpdateOrchestrator，在中间找到Reboot（重启）项，右键单击选择“禁用”。

2. 安装jdk ​

image-20240614151358373

image-20240614151416178

image-20240614151439901

image-20240614151500262

3. 安装SqlServer ​

3.1 下载 ​

bash
ed2k://|file|cn_sql_server_2017_developer_x64_dvd_11296175.iso|1769777152|E21AE7C3576C0BDF1BC0ADC541217FAC|/

Enterprise Core 6GPYM-VHN83-PHDM2-Q9T2R-KBV83
Developer 22222-00000-00000-00000-00000
Enterprise TDKQD-PKV44-PJT4N-TCJG2-3YJ6B
Strandard PHDV4-3VJWD-N7JVP-FGPKY-XBV89
Web WV79P-7K6YG-T7QFN-M3WHF-37BXC
ed2k://|file|cn_sql_server_2017_developer_x64_dvd_11296175.iso|1769777152|E21AE7C3576C0BDF1BC0ADC541217FAC|/

Enterprise Core 6GPYM-VHN83-PHDM2-Q9T2R-KBV83
Developer 22222-00000-00000-00000-00000
Enterprise TDKQD-PKV44-PJT4N-TCJG2-3YJ6B
Strandard PHDV4-3VJWD-N7JVP-FGPKY-XBV89
Web WV79P-7K6YG-T7QFN-M3WHF-37BXC

SQL Server 2022官方下载地址 ​

https://www.microsoft.com/zh-cn/evalcenter/download-sql-server-2022

SQL Server 2019官方下载地址 ​

https://www.microsoft.com/zh-cn/evalcenter/download-sql-server-2019

SQL Server 2017官方下载地址 ​

https://www.microsoft.com/zh-cn/evalcenter/download-sql-server-2017-rtm

SQL Server 2016官方下载地址 ​

https://www.microsoft.com/zh-cn/evalcenter/download-sql-server-2016

激活密钥 ​

SQL Server 2022 ​

Serials:
Developer: 22222-00000-00000-00000-00000
Enterprise: J4V48-P8MM4-9N3J9-HD97X-DYMRM
Enterprise Core: 2Q48Q-PB48J-DRCVN-GB844-X2H4Q
Standard: FG86G-CHH2T-CB7NJ-XT7D2-V8V4X
Web: 2R97W-F4XNT-T6MYV-3TKB7-6X3JM
Serials:
Developer: 22222-00000-00000-00000-00000
Enterprise: J4V48-P8MM4-9N3J9-HD97X-DYMRM
Enterprise Core: 2Q48Q-PB48J-DRCVN-GB844-X2H4Q
Standard: FG86G-CHH2T-CB7NJ-XT7D2-V8V4X
Web: 2R97W-F4XNT-T6MYV-3TKB7-6X3JM

SQL Server 2019 ​

Enterprise：HMWJ3-KY3J2-NMVD7-KG4JR-X2G8G
Enterprise Core：2C9JR-K3RNG-QD4M4-JQ2HR-8468J
Strandard：PMBDC-FXVM3-T777P-N4FY8-PKFF4
Web：33QQK-WWQNB-G6T46-C86YB-TX2PH
Enterprise：HMWJ3-KY3J2-NMVD7-KG4JR-X2G8G
Enterprise Core：2C9JR-K3RNG-QD4M4-JQ2HR-8468J
Strandard：PMBDC-FXVM3-T777P-N4FY8-PKFF4
Web：33QQK-WWQNB-G6T46-C86YB-TX2PH

SQL Server 2017 ​

Enterprise：TDKQD-PKV44-PJT4N-TCJG2-3YJ6B
Enterprise Core：6GPYM-VHN83-PHDM2-Q9T2R-KBV83
Strandard：PHDV4-3VJWD-N7JVP-FGPKY-XBV89
Web：WV79P-7K6YG-T7QFN-M3WHF-37BXC
Enterprise：TDKQD-PKV44-PJT4N-TCJG2-3YJ6B
Enterprise Core：6GPYM-VHN83-PHDM2-Q9T2R-KBV83
Strandard：PHDV4-3VJWD-N7JVP-FGPKY-XBV89
Web：WV79P-7K6YG-T7QFN-M3WHF-37BXC

SQL Server 2016 ​

Enterprise：MDCJV-3YX8N-WG89M-KV443-G8249
Enterprise Core：TBR8B-BXC4Y-298NV-PYTBY-G3BCP
Standard：B9GQY-GBG4J-282NY-QRG4X-KQBCR
Web：BXJTY-X3GNH-WHTHG-8V3XK-T8243
Enterprise：MDCJV-3YX8N-WG89M-KV443-G8249
Enterprise Core：TBR8B-BXC4Y-298NV-PYTBY-G3BCP
Standard：B9GQY-GBG4J-282NY-QRG4X-KQBCR
Web：BXJTY-X3GNH-WHTHG-8V3XK-T8243

SQL Server 2014 ​

Business Intelligence：GJPF4-7PTW4-BB9JH-BVP6M-WFTMJ
Developer：82YJF-9RP6B-YQV9M-VXQFR-YJBGX
Enterprise：27HMJ-GH7P9-X2TTB-WPHQC-RG79R
Enterprise Core：TJYBJ-8YGH6-QK2JJ-M9DFB-D7M9D
Strandard：P7FRV-Y6X6Y-Y8C6Q-TB4QR-DMTTK
Web：J9MBB-R8PMP-R8WTW-8JJRD-C6GGW
Business Intelligence：GJPF4-7PTW4-BB9JH-BVP6M-WFTMJ
Developer：82YJF-9RP6B-YQV9M-VXQFR-YJBGX
Enterprise：27HMJ-GH7P9-X2TTB-WPHQC-RG79R
Enterprise Core：TJYBJ-8YGH6-QK2JJ-M9DFB-D7M9D
Strandard：P7FRV-Y6X6Y-Y8C6Q-TB4QR-DMTTK
Web：J9MBB-R8PMP-R8WTW-8JJRD-C6GGW

3.2 安装 ​

image-20240614153047036

image-20240614153119202

image-20240614153211561

image-20240614153236983

image-20240614153305606

image-20240614153333814

image-20240614153431883

除了机器学习不选,其他都选择上

image-20240614153709125

image-20240614153802624

image-20240614153833928

image-20240614153919454

image-20240614154036167

image-20240614154107516

image-20240614154129583

image-20240614154205093

image-20240614154235068

image-20240614154253051

image-20240614155034525

保证这里都是成功

3.3 验证是否激活 ​

sql
use master
go
RECONFIGURE
GO
DECLARE @daysleft int
DECLARE @instancename sysname
SELECT @instancename = CONVERT(sysname, SERVERPROPERTY('InstanceName'))
EXEC @daysleft = xp_qv '2715127595', @instancename
SELECT @daysleft '剩余使用天数'
GO
use master
go
RECONFIGURE
GO
DECLARE @daysleft int
DECLARE @instancename sysname
SELECT @instancename = CONVERT(sysname, SERVERPROPERTY('InstanceName'))
EXEC @daysleft = xp_qv '2715127595', @instancename
SELECT @daysleft '剩余使用天数'
GO

执行下方脚本，显示为“0”，表示已经激活

4.服务启动管理 ​

4.1 SQL Server配置管理器 ​

推荐这个方式

image

4.2 通过系统服务窗口 ​

image

4.3 通过CMD ​

bash
Net Start MsSqlServer       //启动Sql Server服务

Net Pause MSSqlServer       //暂停Sql Server服务

Net Continue MSSqlServer    //重新启动暂停的Sql Server服务

Net Stop MSSqlServer        //停止Sql Server服务
Net Start MsSqlServer       //启动Sql Server服务

Net Pause MSSqlServer       //暂停Sql Server服务

Net Continue MSSqlServer    //重新启动暂停的Sql Server服务

Net Stop MSSqlServer        //停止Sql Server服务