sqlserver express2005-2019全版本下载地址

我用的是免费的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、www.msdn.hk。

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://aka.ms/ssmsfullsetup

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是英文版

sqlserver 2005一共有5个版本,最后一个版本(sp4)兼容性是最高的,兼容所有机器(已经解决了后面绿色部分描述的2个bug),建议用sp4版本

SqlServer2005最初的版本号(sp0)是2005.90.1399

SQL Server 2005 Service Pack 1 版本号是2005.90.2047

SQL Server 2005 Service Pack 2 版本号是2005.90.3042

SQL Server 2005 Service Pack 3 版本号是2005.90.4035

SQL Server 2005 Service Pack 4 版本号是2005.90.5000

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的版本可以成功安装)

Microsoft SQL Server Management Studio Express SP1

(仅32位):

https://download.microsoft.com/download/1/1/0/110d908f-c445-4523-b939-220c7d135f3d/SQLServer2005_SSMSEE.msi

(仅64位):

https://download.microsoft.com/download/1/1/0/110d908f-c445-4523-b939-220c7d135f3d/SQLServer2005_SSMSEE_x64.msi

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

https://download.microsoft.com/download/2/8/2/282dd027-35f4-4409-a723-4fb11df02d50/SQLEXPR_TOOLKIT_CHS.EXE

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版):

https://download.microsoft.com/download/c/6/b/c6bc0c06-0e01-4362-8554-1ecb5f186462/SQLEXPR_ADV_CHS.EXE

(部分CPU核数不是2的n次方的机器安装会报错,2的0次方是1,1次方是2,2次方是4,3次方是8……只有不是2的n次方核数的CPU都会有问题,sqlserver2005 express with sp2/sp3/sp4的版本可以成功安装)

Microsoft SQL Server Management Studio Express Service Pack 2

https://www.microsoft.com/zh-CN/download/details.aspx?id=15366

https://www.microsoft.com/en-US/download/details.aspx?id=15366

(仅32位):

https://download.microsoft.com/download/0/f/9/0f9d8ac6-d9a2-4233-ae78-4f957f0361e8/SQLServer2005_SSMSEE.msi

(仅64位):

https://download.microsoft.com/download/0/f/9/0f9d8ac6-d9a2-4233-ae78-4f957f0361e8/SQLServer2005_SSMSEE_x64.msi

Microsoft SQL Server 2005 Express Edition SP2工具包

http://www.download.windowsupdate.com/msdownload/update/v3-19990518/cabpool/sqlexpr_toolkit_chs_5aa6a4177f7fd8bff0eba7cead2d87aa75fbb03d.exe

Microsoft SQLServer 2005 Express Edition SP3 官方简体中文免费版[41M](非advance版本不含SMSS,文件名:SQLEXPR32_CHS.EXE含有明确的32字样,此为32位版本,不支持64位系统)

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位系统均可安装的微软下载地址,复制粘贴到迅雷:

http://download.microsoft.com/download/3/D/4/3D45B165-4A80-4B4E-AFAF-2138D9C5A746/SQLEXPR_ADV_CHS.EXE

Microsoft SQL Server 2005 Express Edition SP3工具包

复制粘贴到迅雷:

http://download.microsoft.com/download/D/9/F/D9FE4C15-BB2C-48A8-ACEB-B59B0738ACED/SQLEXPR_TOOLKIT_CHS.EXE

微软能下载:

http://download.windowsupdate.com/msdownload/update/software/svpk/2009/01/sqlexpr_toolkit_chs_2f48d3cbd340e9bff41069b386c826de3173b671.exe

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位):

http://download.microsoft.com/download/5/4/F/54F476B4-2348-4D4A-B705-0C8C9AB2A14A/SQLServer2005_SSMSEE.msi

(仅64位):

http://download.microsoft.com/download/5/4/F/54F476B4-2348-4D4A-B705-0C8C9AB2A14A/SQLServer2005_SSMSEE_x64.msi

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版),复制粘贴到迅雷:

http://download.microsoft.com/download/5/1/9/5199BCFB-28C8-493E-ACFC-D142C52A1539/SQLEXPR_ADV_CHS.EXE

Microsoft SQL Server 2005 Express Edition SP4工具包

复制粘贴到迅雷:

http://download.microsoft.com/download/5/1/9/5199BCFB-28C8-493E-ACFC-D142C52A1539/SQLEXPR_TOOLKIT_CHS.EXE

微软能下载:http://download.windowsupdate.com/msdownload/update/software/svpk/2011/01/sqlexpr_toolkit_chs_bded20dc202e7919f2f295c49c3e36ecbe9cba49.exe

Microsoft SQL Server 2005 Management Studio Express SP4

(仅32位),复制粘贴到迅雷:

http://download.microsoft.com/download/B/5/1/B51566FB-941F-41EF-A528-2EC046EF7DD9/CHS/x86/SQLServer2005_SSMSEE.msi

(仅64位),复制粘贴到迅雷:

http://download.microsoft.com/download/B/5/1/B51566FB-941F-41EF-A528-2EC046EF7DD9/CHS/x64/SQLServer2005_SSMSEE.msi

Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)

http://download.windowsupdate.com/msdownload/update/software/svpk/2011/01/sqlserver2005expresssp4-kb2463332-x86-chs_db802473ade4de6d91fe705585a95d3db338c950.exe

具有高级服务的 Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)

http://download.windowsupdate.com/msdownload/update/software/svpk/2011/01/sqlserver2005expressadvancedsp4-kb2463332-x86-chs_ddb427cc0b0c24e7b40a71b8f201e6ce3f6d136c.exe

SqlServer2000没有express版本,这里只简述下注意事项,不列举下载地址。SqlServer2000有sp4,先安装SqlServer2000再安装sp4,SqlServer2000的兼容性存在问题,部分机器安装报错,需要在安装SqlServer2000之前改造注册表,具体请参考https://cloud.tencent.com/developer/ask/220694

另外,SqlServer2000最高只能安装到Win8.x和Server 2012 R2,不能安装到win10、server2016或以上的系统。

发表评论

您的电子邮箱地址不会被公开。