Win10系统安装SQL2008 R2详细步骤+图片+常见问题及解决方法

偏执的太偏执、 2022-08-29 05:57 603阅读 0赞

**一、安装教程**

软件下载地址请参考此教程：[https://blog.csdn.net/weixin\_43468667/article/details/89073817?ops\_request\_misc=&request\_id=&biz\_id=102&utm\_term=sql2008r2%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B&utm\_medium=distribute.pc\_search\_result.none-task-blog-2allsobaiduweb~default-5-.nonecase&spm=1018.2226.3001.4187][https_blog.csdn.net_weixin_43468667_article_details_89073817_ops_request_misc_request_id_biz_id_102_utm_term_sql2008r2_E5_AE_89_E8_A3_85_E6_95_99_E7_A8_8B_utm_medium_distribute.pc_search_result.none-task-blog-2allsobaiduweb_default-5-.nonecase_spm_1018.2226.3001.4187].

注意：以上教程中下载的压缩包解压出来的是下图所示的.iso文件。  
![在这里插入图片描述][21d7b704637243edbf47887d128449ee.png_pic_center]  
如下图所示，双击cn\_sql\_server\_2008\_r2\_x86\_x64.iso文件，根据如上教程开始安装。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center]  
之后就可以参照此教程进行安装：[https://blog.csdn.net/weixin\_43468667/article/details/89073817?ops\_request\_misc=&request\_id=&biz\_id=102&utm\_term=sql2008r2%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B&utm\_medium=distribute.pc\_search\_result.none-task-blog-2allsobaiduweb~default-5-.nonecase&spm=1018.2226.3001.4187][https_blog.csdn.net_weixin_43468667_article_details_89073817_ops_request_misc_request_id_biz_id_102_utm_term_sql2008r2_E5_AE_89_E8_A3_85_E6_95_99_E7_A8_8B_utm_medium_distribute.pc_search_result.none-task-blog-2allsobaiduweb_default-5-.nonecase_spm_1018.2226.3001.4187].

**二、问题及解决**

大家在安装过程里可能会出现“is not a valid login or you do not hava a permission”的弹出警告从而导致安装失败，解决方法是卸载已经按照的SQL2008的所有程序——>修改自己的电脑名称——>重启电脑——>重新安装。

具体步骤可以参考此教程：[https://blog.csdn.net/wangwenru6688/article/details/50707239?ops\_request\_misc=%257B%2522request%255Fid%2522%253A%2522162771561416780366583359%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request\_id=162771561416780366583359&biz\_id=0&utm\_medium=distribute.pc\_search\_result.none-task-blog-2allsobaiduend~default-1-50707239.pc\_search\_result\_before\_js&utm\_term=is+not+a+valid+login+or+you+do&spm=1018.2226.3001.4187][https_blog.csdn.net_wangwenru6688_article_details_50707239_ops_request_misc_257B_2522request_255Fid_2522_253A_2522162771561416780366583359_2522_252C_2522scm_2522_253A_252220140713.130102334_2522_257D_request_id_162771561416780366583359_biz_id_0_utm_medium_distribute.pc_search_result.none-task-blog-2allsobaiduend_default-1-50707239.pc_search_result_before_js_utm_term_is_not_a_valid_login_or_you_do_spm_1018.2226.3001.4187].

![在这里插入图片描述][74d56369771b4d168746a97d7176ee12.png_pic_center]

**三、安装完毕后运行**

安装如上教程安装后，电脑桌面不会自动出现软件图标，但是我们可以在【开始】单击“SQL Server Management Studio”运行软件。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center 1]  
安装成功页面：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center 2]

[https_blog.csdn.net_weixin_43468667_article_details_89073817_ops_request_misc_request_id_biz_id_102_utm_term_sql2008r2_E5_AE_89_E8_A3_85_E6_95_99_E7_A8_8B_utm_medium_distribute.pc_search_result.none-task-blog-2allsobaiduweb_default-5-.nonecase_spm_1018.2226.3001.4187]: https://blog.csdn.net/weixin_43468667/article/details/89073817?ops_request_misc=&request_id=&biz_id=102&utm_term=sql2008r2%E5%AE%89%E8%A3%85%E6%95%99%E7%A8%8B&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-5-.nonecase&spm=1018.2226.3001.4187
[21d7b704637243edbf47887d128449ee.png_pic_center]: /images/20220829/220e3ce8ed154fab8dd336102526ec96.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center]: /images/20220829/3a085d52ffa1480caa0209305d08ded9.png
[https_blog.csdn.net_wangwenru6688_article_details_50707239_ops_request_misc_257B_2522request_255Fid_2522_253A_2522162771561416780366583359_2522_252C_2522scm_2522_253A_252220140713.130102334_2522_257D_request_id_162771561416780366583359_biz_id_0_utm_medium_distribute.pc_search_result.none-task-blog-2allsobaiduend_default-1-50707239.pc_search_result_before_js_utm_term_is_not_a_valid_login_or_you_do_spm_1018.2226.3001.4187]: https://blog.csdn.net/wangwenru6688/article/details/50707239?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162771561416780366583359%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162771561416780366583359&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-1-50707239.pc_search_result_before_js&utm_term=is+not+a+valid+login+or+you+do&spm=1018.2226.3001.4187
[74d56369771b4d168746a97d7176ee12.png_pic_center]: /images/20220829/fb5b937ca47d4b329c8e1a5184bb75af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20220829/d9818c4e3cc84b26872d59bd4e59d6fe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NzA2MjkwNw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20220829/f97c34c82ea345599450df458f581200.png