我用的是免费的Express with Advanced Services (SQLEXPRADV),sqlserver2016-2019的这个包不含SQL Server Management Studio (SSMS),需要单独安装SSMS或Azure Data Studio,sqlserver2005-2014这个包是含有SMSS的无需额外安装。优先在微软官网下载,如果找不到官网地址,均可在msdn.itellyou.cn下载,下载的时候注意下载最后一个稳定版本(一般是带最高版本service pack的那个),如果msdn.itellyou.cn访问不了,还可以访问www.imsdn.cn。
SQL Server 2019 Express微软官网下载地址:
https://go.microsoft.com/fwlink/?linkid=866658
https://download.microsoft.com/download/2/1/6/216eb471-e637-4517-97a6-b247d8051759/SQL2019-SSEI-Expr.exe
注意:sqlserver2019在Windows上有操作系统限制:≥Windows 10 TH1 1507 、≥Windows Server 2016
SQL Server 2017 Express 微软官网下载地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=55994
https://go.microsoft.com/fwlink/?linkid=853017
https://download.microsoft.com/download/5/E/9/5E9B18CC-8FD5-467E-B5BF-BADE39C51F73/SQLServer2017-SSEI-Expr.exe
SQL Server 2016 Express with SP2微软官网下载地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=56840
https://go.microsoft.com/fwlink/?LinkID=799012
http://download.microsoft.com/download/3/7/6/3767D272-76A1-4F31-8849-260BD37924E4/SQLServer2016-SSEI-Expr.exe
客户端软件:Azure Data Studio 、SQL Server Management Studio (SSMS)
Azure Data Studio 在 Windows、macOS 和 Linux 上运行,SSMS只在Windows上运行。
SSMS微软官网下载地址:
https://download.microsoft.com/download/1/9/4/1949aa9c-6536-48f2-81fa-e7bb07410b36/SSMS-Setup-CHS.exe
Azure Data Studio微软官网下载地址:
https://docs.microsoft.com/zh-cn/sql/azure-data-studio/download-azure-data-studio
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
https://go.microsoft.com/fwlink/?linkid=2113628
sqlserver 2014 express with advance service with sp2迅雷下载链接:
ed2k://|file|cn_sql_server_2014_express_with_advanced_services_with_service_pack_2_x64_9009619.exe|1622450592|D0A581C529E599D6A661EC3EC96CDDC6|/
ed2k://|file|cn_sql_server_2014_express_with_advanced_services_with_service_pack_2_x86_9009619.exe|1589381968|C282393D5C5230BF2895193EE7575F6E|/
sqlserver 2014 express with advance service with sp2微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=53167
https://download.microsoft.com/download/8/A/D/8AD11CE2-E335-4B17-B3FB-479803CDE24F/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/8/A/D/8AD11CE2-E335-4B17-B3FB-479803CDE24F/SQLEXPRADV_x86_CHS.exe
sqlserver 2014 express with advance service with sp3微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=57473
https://download.microsoft.com/download/8/8/1/8818970B-38B5-47C4-BEA5-916436B9C540/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/8/8/1/8818970B-38B5-47C4-BEA5-916436B9C540/SQLEXPRADV_x86_CHS.exe
sqlserver 2012 express with advance service with sp4微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=56042
https://download.microsoft.com/download/A/4/3/A43F9D8D-5346-441A-ABAE-86C3AFE17B4D/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/A/4/3/A43F9D8D-5346-441A-ABAE-86C3AFE17B4D/SQLEXPRADV_x86_CHS.exe
sqlserver 2008 r2 express with advance service微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=25174
https://download.microsoft.com/download/7/1/9/719FC552-53C5-4082-AE0B-F43B14F6E997/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/7/1/9/719FC552-53C5-4082-AE0B-F43B14F6E997/SQLEXPRADV_x86_CHS.exe
sqlserver 2008 r2 express with advance service with sp2微软官网地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=30438
https://download.microsoft.com/download/9/4/8/948966AB-52CA-40F1-8051-0216481065E6/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/9/4/8/948966AB-52CA-40F1-8051-0216481065E6/SQLEXPRADV_x86_CHS.exe
SQL Server 2008 R2 Service Pack 3微软官网地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=44271
https://download.microsoft.com/download/9/6/4/964BB4EC-FC28-4DA7-9295-7D4A8FDBE1A4/CHS/SQLServer2008R2SP3-KB2979597-x64-CHS.exe
https://download.microsoft.com/download/9/6/4/964BB4EC-FC28-4DA7-9295-7D4A8FDBE1A4/CHS/SQLServer2008R2SP3-KB2979597-x86-CHS.exe
sql server 2008 express with advance service微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=1842
https://download.microsoft.com/download/1/b/d/1bdda531-8346-4347-ab96-f55a1c5015bf/SQLEXPRADV_x64_CHS.exe
https://download.microsoft.com/download/1/b/d/1bdda531-8346-4347-ab96-f55a1c5015bf/SQLEXPRADV_x86_CHS.exe
sql server 2008 express (非advance版本不含SMSS)with sp3微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=27597
https://download.microsoft.com/download/5/5/1/5511B1E4-8A8A-49AE-AA3C-64D738B813FA/SQLEXPR_x64_CHS.exe
https://download.microsoft.com/download/5/5/1/5511B1E4-8A8A-49AE-AA3C-64D738B813FA/SQLEXPR_x86_CHS.exe
SQL Server 2008 Service Pack 3微软官网地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=27594
https://download.microsoft.com/download/A/6/4/A6469E59-63A8-49A3-9FF2-FE0C56B59790/SQLServer2008SP3-KB2546951-x64-CHS.exe
https://download.microsoft.com/download/A/6/4/A6469E59-63A8-49A3-9FF2-FE0C56B59790/SQLServer2008SP3-KB2546951-x86-CHS.exe
SQL Server 2008 Service Pack 4微软官网地址:
https://www.microsoft.com/zh-cn/download/details.aspx?id=44278
https://download.microsoft.com/download/A/A/F/AAFADFB7-885D-40D6-AD1C-40B63CEDAA84/CHS/SQLServer2008SP4-KB2979596-x64-CHS.exe
https://download.microsoft.com/download/A/A/F/AAFADFB7-885D-40D6-AD1C-40B63CEDAA84/CHS/SQLServer2008SP4-KB2979596-x86-CHS.exe
sqlserver2005的版本比较多,我常用express版本
SQLEXPR32_x86_CHS.exe只能在32位的操作系统下运行使用
SQLEXPR_x86_CHS.exe既可以在32位操作系统下运行,也可以在64位操作系统下运行使用
SQLEXPR_x64_CHS.exe只能在64位的操作系统下运行使用
CHS是中文版,不带CHS或带ENU是英文版
sqlserver2005 express [sqlserver2005最初的版本号(sp0)是2005.90.1399]微软官网地址:
https://www.microsoft.com/zh-CN/download/details.aspx?id=21844
(仅32位):
中文版:https://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR32_CHS.EXE
英文版:http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/SQLEXPR32.EXE
(32位、64位系统均可安装):
中文版:https://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE
英文版:http://download.microsoft.com/download/f/1/0/f10c4f60-630e-4153-bd53-c3010e4c513b/SQLEXPR.EXE
部分CPU核数不是2的n次方的机器安装会报错,2的0次方是1,1次方是2,2次方是4,3次方是8……只有不是2的n次方核数的CPU都会有问题,SqlServer2005 express with sp2/sp3/sp4的版本可以成功安装;另外,即便是CPU核数本来就是2的n次方的机器,比如2的0次方,1核机器,此版本的sqlserver即2005.90.1399版本的sqlserver在>=server2012系统上安装时报错,测试sp1/sp2/sp3/sp4版本的均可成功安装。
sp1版本安装过程中大概率会出现上图警告,一直点“重试”按钮(大概点六七次吧)直到安装完成,测试可用。
为了省事,建议大家还是直接安装sp4版本,兼容性最好。
sqlserver2005 express with sp1 版本号是2005.90.2047
微软官方地址已经404,需用迅雷下载
(仅32位),复制粘贴到迅雷:
http://download.microsoft.com/download/9/f/a/9fa2d488-13a8-41c4-9fd3-3bf0965313a9/SQLEXPR32_CHS.EXE
(32位、64位系统均可安装),复制粘贴到迅雷:
http://download.microsoft.com/download/9/f/a/9fa2d488-13a8-41c4-9fd3-3bf0965313a9/SQLEXPR_CHS.EXE
(部分CPU核数不是2的n次方的机器安装会报错,2的0次方是1,1次方是2,2次方是4,3次方是8……只有不是2的n次方核数的CPU都会有问题,sqlserver2005 express with sp2/sp3/sp4的版本可以成功安装)
(仅32位):
(仅64位):
Microsoft SQL Server 2005 Express Edition SP1工具包
https://www.microsoft.com/en-us/download/details.aspx?id=19413
https://www.microsoft.com/zh-CN/download/details.aspx?id=19413
sqlserver2005 express with advance service with sp1(32位、64位系统均可)
链接: https://pan.baidu.com/s/1mnZnt9HW1t7hE_yI6YeZkw
提取码: gmcg
sqlserver2005 express with advance service with sp2微软官网地址:
SQL Server 2005 Service Pack 2 版本号是2005.90.3042
https://www.microsoft.com/zh-CN/download/details.aspx?id=12980
(32位、64位系统均可安装,advance版):
(部分CPU核数不是2的n次方的机器安装会报错,2的0次方是1,1次方是2,2次方是4,3次方是8……只有不是2的n次方核数的CPU都会有问题,sqlserver2005 express with sp2/sp3/sp4的版本可以成功安装)
https://www.microsoft.com/zh-CN/download/details.aspx?id=15366
https://www.microsoft.com/en-US/download/details.aspx?id=15366
(仅32位):
(仅64位):
Microsoft SQL Server 2005 Express Edition SP2工具包
SQL Server 2005 Service Pack 3 版本号是2005.90.4035
https://www.jb51.net/softs/34485.html
文件名:SQLEXPR32_CHS.EXE,微软官网下载地址已经失效但是开通迅雷会员用迅雷就能下载
只能32位系统安装的微软下载地址,复制粘贴到迅雷:http://download.microsoft.com/download/C/E/6/CE626F95-EBD3-4AB8-AA35-C1BFAF98B7D5/SQLEXPR32_CHS.EXE
百度网盘链接:https://pan.baidu.com/s/1xdCk9x2BGUmE1qjhMLBLDw 密码:010b
32位、64位系统均可安装的微软下载地址,复制粘贴到迅雷:http://download.microsoft.com/download/C/E/6/CE626F95-EBD3-4AB8-AA35-C1BFAF98B7D5/SQLEXPR_CHS.EXE
百度网盘链接:https://pan.baidu.com/s/1VsiRmRJjeKCTkFw6FOXmTA 密码:gni2
上面2个微软地址已经404,但在迅雷里可以下载。专门花15块钱买了一个月迅雷白金会员做了个实验,微软下载链接404,但是在迅雷里开通会员就能下载,这是因为迅雷服务器里记录了原始URL并保留了曾经别人下载过的原文件。
sqlserver2005 express with advance service with sp3 (32位、64位系统均可)
SQL Server 2005 Service Pack 3 版本号是2005.90.4035
文件名:SQLEXPR_ADV_CHS.EXE,微软官网下载地址已经失效但是开通迅雷会员用迅雷就能下载
我已经下载好放到百度网盘了:
链接:https://pan.baidu.com/s/1-2kDGvR3BSW-0N1PUJWaNg 密码:yxhf
advance版,32位、64位系统均可安装的微软下载地址,复制粘贴到迅雷:
Microsoft SQL Server 2005 Express Edition SP3工具包
复制粘贴到迅雷:
微软能下载:
Microsoft SQL Server Management Studio Express SP3
https://www.microsoft.com/en-my/download/details.aspx?id=8961
https://www.microsoft.com/zh-CN/download/details.aspx?id=8961
(仅32位):
(仅64位):
sqlserver2005 express with advance service with sp4迅雷下载地址:
SQL Server 2005 Service Pack 4 版本号是2005.90.5000
复制粘贴到迅雷
ed2k://|file|cn_sql_server_2005_express_edition_with_advanced_services_with_SP4_x86&x64.exe|279297888|3AC9C4620D654F57E5F10C332000C386|/
下面2个sp4的简版需用迅雷下载
(仅32位),复制粘贴到迅雷:
http://download.microsoft.com/download/5/1/9/5199BCFB-28C8-493E-ACFC-D142C52A1539/SQLEXPR32_CHS.EXE
(32位、64位系统均可),复制粘贴到迅雷:
http://download.microsoft.com/download/5/1/9/5199BCFB-28C8-493E-ACFC-D142C52A1539/SQLEXPR_CHS.EXE
(32位、64位系统均可,advance版),复制粘贴到迅雷:
Microsoft SQL Server 2005 Express Edition SP4工具包
复制粘贴到迅雷:
Microsoft SQL Server 2005 Management Studio Express SP4
(仅32位),复制粘贴到迅雷:
(仅64位),复制粘贴到迅雷:
Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)
具有高级服务的 Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)
SqlServer2000没有express版本,这里只简述下注意事项,不过多列举下载地址。SqlServer2000有sp4,先安装SqlServer2000再安装sp4,SqlServer2000的兼容性存在问题,部分机器安装报错,需要在安装SqlServer2000之前改造注册表,具体请参考https://cloud.tencent.com/developer/ask/220694
在msdn.itellyou.cn里搜sql 2000就能搜到迅雷下载地址
SQL2000 SP4微软下载地址已经失效,需要用迅雷下载:http://download.microsoft.com/download/9/b/f/9bff6646-2cdb-4069-ada0-548be9cb9338/SQL2000-KB884525-SP4-x86-CHS.EXE
Hotfix for SQL 2000 SP4 Build 2187微软下载地址目前还未失效,如果失效需要用迅雷下载:http://download.microsoft.com/download/8/b/2/8b225659-6b2b-4be5-ae11-ccd4b17b152b/SQL2000-KB916287-v8.00.2187-x86x64-CHS.exe
另外,SqlServer2000最高只能安装到Win8.x和Server 2012 R2,不能安装到win10、server2016或以上的系统。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。