SQL server 2008 R2 图文安装教程（附资源）

系统管理员 2022-12-27 07:57 172阅读 0赞

# 1 安装环境及所需软件资源（网盘资源已更新永久分享 2020.6.24） #

*  系统环境：Windows 10 Enterprise 64位
 *  SQL版本：sql\_server\_2008\_r2\_enterprise （ [点击百度网盘下载][Link 1] 提取码: 5wr3）
 *  NET Framework 3.5：（ [点击百度网盘下载][Link 2] 提取码: 9dc1）

# 2 安装过程 #

### 2.1 下载并解压 sql\_server\_2008\_r2\_enterprise 点击 setup ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMyNjExMDU1]

> 注：若点击setup后提示系统缺少 NET Framework 3.5 ，请在文章开头的链接下载NET Framework 3.5（若能点击setup后能直接运行，则可忽略该注释，直接进行下方操作）安装教程如下：  
> 1.解压后将 sxs 文件夹复制到C盘目录下  
> ![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1OTMwNjI1]  
> 2.右击 NET Framework 3.5 以管理员身份运行，弹出cmd窗口后，进度条到100%即安装成功，安装成功后即可删除刚刚复制到C盘目录下的 sxs 文件夹。  
> ![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTQwMTMxMjcy]

### 2.2 打开后如图，点击左侧的 安装 ，再点击右边的 “全新安装或向现有安装添加功能 ” ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMyNzQ4NzY1]

### 2.3 安装支持规则，点确定 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzMDMwNDIx]

### 2.4 产品密钥会自动填入，点击下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzMTQ5NjE4]

### 2.5 接受许可条款 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzNDUwNjY2]

### 2.6 点击安装 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzNjA4NDgz]

### 2.7 选择 SQL Server功能安装 ，点击 下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzODE2NjM2]

### 2.8 点击全选，下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTA2ODI4]

### 2.9 选择默认实例，下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTQ2NjE5]

### 2.10 磁盘的空间需求，6000MB 左右 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MTA2ODYx]

### 2.11 点击，对所有SQL Server服务使用相同账户 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjE2MzM5]

### 2.12 选择如图项，确定 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjM2MTUx]

### 2.13 选择*混合模式*，输入密码，点下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDE5NDQ3]

### 2.14 点击下面的添加当前账户，点下一步 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDUzOTcz]

### 2.15 点击添加当前账户 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NTQzOTky]

### 2.16 一路点Next ###

### 2.17 点击安装 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0ODI2MzIz]

### 2.18 安装结束，点击关闭 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0OTAzNDIx]

### 2.19 在快速启动中找到安装目录，点击 SQL Server Management Studio ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MDUxMjIw]

### 2.20 连接到服务器，服务器名称填入计算机名即可 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MzExMjg3]

### 2.21 运行成功 ###

![这里写图片描述][aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1NDIxMjgw]

[Link 1]: https://pan.baidu.com/s/1neD30DL14nvk3V7xEF4R8A
[Link 2]: https://pan.baidu.com/s/1USf8XzecncwXb1EMs4Nymg
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMyNjExMDU1]: /images/20221120/f74f36b48f08430a8ee9ad5f03cfefd8.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1OTMwNjI1]: /images/20221120/52568a9bd2634100a10ddc494e737a01.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTQwMTMxMjcy]: /images/20221120/20bbc64161e748e3ae44b48e592dcefe.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMyNzQ4NzY1]: /images/20221120/390fa8112be64cfab3eccae20e9d6ac6.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzMDMwNDIx]: /images/20221120/b42c4a2dbc8e4438837394c5691b1545.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzMTQ5NjE4]: /images/20221120/bc2157f8d79044e7a985ac0689e006b5.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzNDUwNjY2]: /images/20221120/1fb35a29587b4243ac91288866d8a0ef.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzNjA4NDgz]: /images/20221120/79beb811ad1f478e978227d8cc00f1e4.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzODE2NjM2]: /images/20221120/cf444a35f7614ea9b23a78a84ae052d0.png
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTA2ODI4]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTA2ODI4
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTQ2NjE5]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTMzOTQ2NjE5
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MTA2ODYx]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MTA2ODYx
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjE2MzM5]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjE2MzM5
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjM2MTUx]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0MjM2MTUx
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDE5NDQ3]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDE5NDQ3
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDUzOTcz]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NDUzOTcz
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NTQzOTky]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0NTQzOTky
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0ODI2MzIz]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0ODI2MzIz
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0OTAzNDIx]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM0OTAzNDIx
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MDUxMjIw]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MDUxMjIw
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MzExMjg3]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1MzExMjg3
[aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1NDIxMjgw]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLmNzZG4ubmV0LzIwMTgwMzE0MTM1NDIxMjgw