欢乐狗 发表于 2022-6-25 05:42:51

SQL server 2008 r2 安装教程

1、下载sql server 2008 r2的安装包(如果需要安装包可以私我,密钥自动输入)
2、打开安装包,点击setup.exe
https://img-blog.csdnimg.cn/20210529155016525.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
3、点击“安装”,下一步选择“全新安装或向现有的安装添加功能”
https://img-blog.csdnimg.cn/20210529155219227.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
4、检测完成后点击确定
https://img-blog.csdnimg.cn/20210529155417248.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
5、选择输入产品密钥,这里会自动输入,下一步
https://img-blog.csdnimg.cn/20210529155537804.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
6、选择“我接受许可条款”,下一步
https://img-blog.csdnimg.cn/20210529155628858.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
7、选择“安装”
https://img-blog.csdnimg.cn/20210529161114389.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
8、检测无误后,点击“下一步”
https://img-blog.csdnimg.cn/20210529161255882.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
9、选择”SQL server功能安装“,点击”下一步“
https://img-blog.csdnimg.cn/20210529161522726.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
10、这里全选,我这里选择的是默认路径c盘的,也可以选择放在其他目录下。点击”下一步“。
https://img-blog.csdnimg.cn/20210529161752910.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
11、检测无误后,下一步
https://img-blog.csdnimg.cn/20210529161843659.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
12、默认路径或者需要自己命令路径,注意一下改路径。
https://img-blog.csdnimg.cn/20210529162040636.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
13、磁盘空间需求,我放的是c盘,下一步
https://img-blog.csdnimg.cn/20210529162214862.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
14、SQL Server代理 选 SYSTEM
SQL Server Database engine 选 NETWORK SERVICE
SQL Server Analysis services 选 NETWORK SERVICE
SQL Server Reporting services 选 NETWORK SERVICE
SQL Server Integration services 选 NETWORK SERVICE
https://img-blog.csdnimg.cn/2021052916272195.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
选择”对所有SQL Server 服务使用相同的账号“,浏览选择”NETWORK SERVICE“,确定,下一步
https://img-blog.csdnimg.cn/20210529164154646.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
15、选择”混合模式“,输入密码,选择添加当前用户,下一步
https://img-blog.csdnimg.cn/20210529162910428.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
16、添加当前用户,下一步
https://img-blog.csdnimg.cn/20210529163109165.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
17、选择”安装本机模式默认配置“,下一步
https://img-blog.csdnimg.cn/20210529163217181.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
18、不选,下一步
https://img-blog.csdnimg.cn/20210529163257642.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
19、检测无误后,下一步
https://img-blog.csdnimg.cn/20210529163320501.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
20、选择”安装“
https://img-blog.csdnimg.cn/20210529163411735.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
21、等待安装,大概需要20—40分钟左右,安装完成后关闭即可
https://img-blog.csdnimg.cn/20210529164435504.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
22、打开数据库,
服务器类型:数据库引擎
服务器名称:(local)下拉没有的,手动输入一下,有括号
身份验证:SQL Server 身份验证
登录名:sa
密码:15步设置的密码
https://img-blog.csdnimg.cn/202105291701194.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70
23、登录成功
https://img-blog.csdnimg.cn/20210529170157840.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MTMyNDQw,size_16,color_FFFFFF,t_70

免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!
页: [1]
查看完整版本: SQL server 2008 r2 安装教程