安装之前，再次测试下系统DSN

点击配置

p_w_picpath2016-12-23%2011%3A4%3A48.png?versio

p_w_picpath2016-12-23%2011%3A5%3A19.png?versio

p_w_picpath2016-12-23%2011%3A5%3A32.png?versio

p_w_picpath2016-12-23%2011%3A5%3A41.png?versio

p_w_picpath2016-12-23%2011%3A5%3A55.png?versio

p_w_picpath2016-12-23%2011%3A4%3A33.png?versio

如果上面测试失败的话，执行一下操作

启用tcp/ip，启用后重启mysql服务

p_w_picpath2016-12-23%2011%3A7%3A37.png?versio

启用远程连接

p_w_picpath2016-12-23%2011%3A18%3A3.png?versio

修改sa账号属性

p_w_picpath2016-12-23%2011%3A18%3A41.png?versi

单独添加1433端口允许入站

p_w_picpath2016-12-23%2011%3A19%3A18.png?versi

一定用本地管理员登录服务器安装

p_w_picpath2016-12-21%2017%3A10%3A9.png?versio

p_w_picpath2016-12-21%2017%3A11%3A57.png?versi

p_w_picpath2016-12-21%2017%3A33%3A5.png?versio

p_w_picpath2016-12-21%2017%3A37%3A10.png?versi

 

p_w_picpath2016-12-23%2016%3A2%3A44.png?versio

出现下面这个错误，需要到组策略里面修改，运行输入gpedit.msc，打开，然后依次定位到“计算机配置”-“Windows配置”-“安全设置”-“本地策略”-“用户权限分配”，然后在右侧双击“作为服务登陆”，在弹出对话框单击“添加用户或组”将帐加入，确认无误后单击“确定”

p_w_picpath2016-12-21%2017%3A44%3A39.png?versi

然后更新组策略

p_w_picpath2016-12-21%2017%3A45%3A34.png?versi

下一步的时候，本地登录sql启用sa账号，然后本地登录sql修改登录的验证方式

p_w_picpath2016-12-22%2016%3A41%3A51.png?versi

p_w_picpath2016-12-22%2016%3A42%3A50.png?versi

p_w_picpath2016-12-22%2016%3A43%3A28.png?versi

p_w_picpath2016-12-22%2016%3A43%3A44.png?versi

p_w_picpath2016-12-22%2016%3A27%3A12.png?versi

下面的端口号，记得关闭防火墙，单独给1433端口加一个入站规则允许类型的

p_w_picpath2016-12-22%2015%3A55%3A49.png?versi

p_w_picpath2016-12-22%2016%3A29%3A28.png?versi

p_w_picpath2016-12-22%2016%3A29%3A40.png?versi

p_w_picpath2016-12-22%2016%3A29%3A51.png?versi

p_w_picpath2016-12-22%2016%3A58%3A38.png?versi

安装完毕

p_w_picpath2016-12-23%2012%3A4%3A48.png?versio

p_w_picpath2016-12-23%2016%3A23%3A35.png?versi