Win7系统之家 - 专注分享最好的电脑系统软件！免费安全下载 Win7系统之家首页 | Win7激活工具 | 热门专题
Win7系统之家> > 系统教程 > Win10系统教程 >

Win10系统SQL server 2014 sa无法登录解决方法

更新时间：2026-08-19 04:37:22 | 编辑：毒盅 | 信息来源：互联网

在Win10系统下安装了SQLserver 2014后使用sa无法登录，SQL Server2014的过程中明明选择了使用Windows身份验证和SQL Server身份验证混合模式，可是安装完之后却不能使用SQL Server身份验证登录，提示“用户'sa'登录失败，错误18456”。下面一起来看看解决方染。

 

解决步骤如下：

1. 在登录窗口设置身份验证，使用Windows身份验证登录数据库。

 

2. 在管理中，右键数据库服务器名，选择【属性】。

 

3. 打开“服务器属性”窗口，选择【安全性】，更改“服务器身份验证”，如下图所示。

4. 展开数据库服务器名—“安全性”—“登录名”， 右键“sa”用户，选择【属性】。

 

5. 打开“登录属性”窗口，选择【常规】，然后输入你的密码。

6. 仍然在“登录属性”窗口，选择【状态】，选择“登录”下面的【已启用】，如下图所示。

7. 右键数据库服务器名，选择【重新启动】，重启SQL Server 2014

8. 重启之后就能使用sa用户SQL Server身份验证成功登录了。

SQL Server 2014 windows身份验证和sa登录失败，一般来说都是以下几个问题1.验证方式不对、2.IP不对，在配置管理器里也进行了检查，需要SetActive的IP，3.怀疑是密码规则不对，



 

上一篇：Win10无法登录到你的账户怎么修复？

下一篇：Windows update medic service服务禁用不了拒绝访问解决方法


相关阅读

教程栏目
站长推荐

正版 Windows 10

正版Windows 10 家庭/专业版，操作系统限时抢购[￥1088→￥248]>>抢优惠券

站长推荐

Office 2024 Pro Plus 专业增强版

办公软件送 Win 11 Pro 專業版 正版最低价仅需498元
>>抢优惠券
Win10系统教程人气排行
热门系统推荐
最新教程
返回顶部


Win7系统之家发布的系统镜像及软件均来至互联网,仅供学习和研究使用，不得用于任何商业用途并请在下载后24小时内删除,如果满意请联系版权方购买。
如果您发现本站侵害了您的版权，请立即联系我们，本站将第一时间进行相关处理。投诉邮箱1524578900@qq.com
版权声明|联系我们 Copyright © Win7系统之家 All Rights Reserved 鲁ICP备2021038877号-4

2.3174
关
大
基本信息
SQL
$_GET
$_POST
$_COOKIE
包含文件
自动加载
  1. 模型: /www/wwwroot/www.pjwan.com/lecms/model/
  2. 视图: /www/wwwroot/www.pjwan.com/view/ww7/w10_show.htm
  3. 控制器: /www/wwwroot/www.pjwan.com/lecms/control/show_control.class.php
  4. 日志目录: /www/wwwroot/www.pjwan.com/log/
  5. 当前页面: /www/wwwroot/www.pjwan.com/index.php
  6. 当前时间: 2026-08-19 04:37:20
  7. 当前网协: 216.73.216.186
  8. 请求路径: /win10jc/17155.html
  9. 运行时间: 2.3174
  10. 内存开销: 1.31 MB
  1. #0 [time:0.0004s] SELECT * FROM le_runtime WHERE k='cfg' LIMIT 1
  2. #1 [time:0.0004s] SELECT * FROM le_runtime WHERE k='cate_127' LIMIT 1
  3. #2 [time:0.0004s] SELECT * FROM le_cms_article WHERE id=17155 LIMIT 1
  4. #3 [time:0.0004s] SELECT * FROM le_user WHERE uid=2 LIMIT 1
  5. #4 [time:0.0003s] SELECT * FROM le_cms_article_data WHERE id=17155 LIMIT 1
  6. #5 [time:0.0003s] SELECT * FROM le_cms_article_views WHERE id=17155 LIMIT 1
  7. #6 [time:0.0004s] UPDATE LOW_PRIORITY le_cms_article_views SET views=views+1 WHERE id=17155 LIMIT 1
  8. #7 [time:0.0003s] SELECT id FROM le_cms_article WHERE id<17155 ORDER BY id DESC LIMIT 0,1
  9. #8 [time:0.0003s] SELECT * FROM le_cms_article WHERE id=17154
  10. #9 [time:0.0003s] SELECT id FROM le_cms_article WHERE id>17155 ORDER BY id ASC LIMIT 0,1
  11. #10 [time:0.0003s] SELECT * FROM le_cms_article WHERE id=17156
  12. #11 [time:0.0003s] SELECT * FROM le_kv WHERE k='navigate' LIMIT 1
  13. #12 [time:0.0003s] SELECT tagid,id FROM le_cms_article_tag_data WHERE tagid=973 ORDER BY id DESC LIMIT 0,11
  14. #13 [time:0.0004s] SELECT * FROM le_cms_article_tag_data WHERE tagid=973 AND id=103441 OR tagid=973 AND id=103329 OR tagid=973 AND id=103274 OR tagid=973 AND id=103160 OR tagid=973 AND id=103106 OR tagid=973 AND id=103105 OR tagid=973 AND id=103090 OR tagid=973 AND id=102988 OR tagid=973 AND id=102905 OR tagid=973 AND id=102623 OR tagid=973 AND id=102586
  15. #14 [time:0.0007s] SELECT * FROM le_cms_article WHERE id=103441 OR id=103329 OR id=103274 OR id=103160 OR id=103106 OR id=103105 OR id=103090 OR id=102988 OR id=102905 OR id=102623
  16. #15 [time:0.0005s] SELECT cid FROM le_category ORDER BY orderby ASC ,cid ASC
  17. #16 [time:0.0015s] SELECT * FROM le_category WHERE cid=1 OR cid=2 OR cid=3 OR cid=4 OR cid=5 OR cid=6 OR cid=7 OR cid=8 OR cid=9 OR cid=10 OR cid=11 OR cid=12 OR cid=13 OR cid=14 OR cid=15 OR cid=16 OR cid=17 OR cid=18 OR cid=19 OR cid=20 OR cid=21 OR cid=22 OR cid=23 OR cid=24 OR cid=25 OR cid=26 OR cid=27 OR cid=28 OR cid=29 OR cid=30 OR cid=31 OR cid=32 OR cid=33 OR cid=34 OR cid=35 OR cid=36 OR cid=37 OR cid=38 OR cid=39 OR cid=40 OR cid=41 OR cid=42 OR cid=43 OR cid=44 OR cid=45 OR cid=46 OR cid=47 OR cid=48 OR cid=49 OR cid=50 OR cid=51 OR cid=52 OR cid=53 OR cid=54 OR cid=55 OR cid=56 OR cid=57 OR cid=58 OR cid=59 OR cid=60 OR cid=61 OR cid=62 OR cid=63 OR cid=64 OR cid=65 OR cid=66 OR cid=67 OR cid=68 OR cid=69 OR cid=70 OR cid=71 OR cid=72 OR cid=73 OR cid=74 OR cid=75 OR cid=76 OR cid=77 OR cid=78 OR cid=79 OR cid=80 OR cid=81 OR cid=82 OR cid=83 OR cid=84 OR cid=85 OR cid=86 OR cid=87 OR cid=88 OR cid=89 OR cid=90 OR cid=91 OR cid=92 OR cid=93 OR cid=94 OR cid=95 OR cid=96 OR cid=97 OR cid=98 OR cid=99 OR cid=100 OR cid=101 OR cid=102 OR cid=103 OR cid=104 OR cid=105 OR cid=106 OR cid=107 OR cid=108 OR cid=109 OR cid=110 OR cid=111 OR cid=112 OR cid=113 OR cid=114 OR cid=115 OR cid=116 OR cid=117 OR cid=118 OR cid=119 OR cid=120 OR cid=121 OR cid=122 OR cid=123 OR cid=124 OR cid=125 OR cid=126 OR cid=127 OR cid=128
  18. #17 [time:0.0003s] SELECT id FROM le_cms_article_views WHERE cid=127 ORDER BY views DESC LIMIT 0,10
  19. #18 [time:0.0003s] SELECT * FROM le_cms_article_views WHERE id=20203 OR id=46933 OR id=46931 OR id=46928 OR id=46927 OR id=46920 OR id=45636 OR id=20216 OR id=46926 OR id=46925
  20. #19 [time:0.0005s] SELECT * FROM le_cms_article WHERE id=20203 OR id=46933 OR id=46931 OR id=46928 OR id=46927 OR id=46920 OR id=45636 OR id=20216 OR id=46926 OR id=46925
  21. #20 [time:0.0003s] SELECT * FROM le_runtime WHERE k='cate_85' LIMIT 1
  22. #21 [time:0.0005s] SELECT id FROM le_cms_win WHERE (cid=86 OR cid=87 OR cid=88 OR cid=89 OR cid=90 OR cid=91 OR cid=92 OR cid=93 OR cid=94 OR cid=95 OR cid=96 OR cid=97 OR cid=98 OR cid=99 OR cid=100) ORDER BY id DESC LIMIT 0,10
  23. #22 [time:0.0004s] SELECT * FROM le_cms_win WHERE id=1027 OR id=1026 OR id=1025 OR id=1024 OR id=1023 OR id=1022 OR id=1021 OR id=1020 OR id=1019 OR id=1018
  24. #23 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_64' LIMIT 1
  25. #24 [time:0.0004s] SELECT id FROM le_cms_article WHERE (cid=65 OR cid=66 OR cid=67 OR cid=68 OR cid=125 OR cid=126 OR cid=127 OR cid=128) ORDER BY id DESC LIMIT 0,10
  26. #25 [time:0.0005s] SELECT * FROM le_cms_article WHERE id=103563 OR id=103562 OR id=103561 OR id=103560 OR id=103559 OR id=103558 OR id=103557 OR id=103556 OR id=103555 OR id=103554
  1. #control => show
  2. #action => index
  3. #cid => 127
  4. #id => 17155
  5. #mid => 2
    1. #acw_tc => 0819529e17870854223177297e831248f9b53497d49d72c7a77ed01c4b
    2. #cdn_sec_tc => 0819529e17870854223177297e831248f9b53497d49d72c7a77ed01c4b
    3. #PHPSESSID => nmu43l2sjibk815oot0i3g0dk3
    1. #0 /www/wwwroot/www.pjwan.com/index.php
    2. #1 /www/wwwroot/www.pjwan.com/lecms/xiunophp/xiunophp.php
    3. #2 /www/wwwroot/www.pjwan.com/lecms/config/config.inc.php
    4. #3 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/base.func.php
    5. #4 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/core.class.php
    6. #5 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/debug.class.php
    7. #6 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/log.class.php
    8. #7 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/model.class.php
    9. #8 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/view.class.php
    10. #9 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/control.class.php
    11. #10 /www/wwwroot/www.pjwan.com/lecms/xiunophp/db/db.interface.php
    12. #11 /www/wwwroot/www.pjwan.com/lecms/xiunophp/db/db_pdo_mysql.class.php
    13. #12 /www/wwwroot/www.pjwan.com/lecms/xiunophp/cache/cache.interface.php
    14. #13 /www/wwwroot/www.pjwan.com/lecms/xiunophp/cache/cache_memcache.class.php
    15. #14 /www/wwwroot/www.pjwan.com/lecms/xiunophp/ext/network/Network__interface.php
    16. #15 /www/wwwroot/www.pjwan.com/lecms/config/plugin.inc.php
    17. #16 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_sd/conf.php
    18. #17 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_tinymce/conf.php
    19. #18 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_um/conf.php
    20. #19 /www/wwwroot/www.pjwan.com/lecms/plugin/le_adminer/conf.php
    21. #20 /www/wwwroot/www.pjwan.com/lecms/plugin/le_baidu_zz/conf.php
    22. #21 /www/wwwroot/www.pjwan.com/lecms/plugin/le_category_filter/conf.php
    23. #22 /www/wwwroot/www.pjwan.com/lecms/plugin/le_content_tag_url/conf.php
    24. #23 /www/wwwroot/www.pjwan.com/lecms/plugin/le_data_table_split/conf.php
    25. #24 /www/wwwroot/www.pjwan.com/lecms/plugin/le_drafts/conf.php
    26. #25 /www/wwwroot/www.pjwan.com/lecms/plugin/le_feedback/conf.php
    27. #26 /www/wwwroot/www.pjwan.com/lecms/plugin/le_homepage_feign/conf.php
    28. #27 /www/wwwroot/www.pjwan.com/lecms/plugin/le_html_cache/conf.php
    29. #28 /www/wwwroot/www.pjwan.com/lecms/plugin/le_links/conf.php
    30. #29 /www/wwwroot/www.pjwan.com/lecms/plugin/le_minganci_do/conf.php
    31. #30 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand404content/conf.php
    32. #31 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand_author/conf.php
    33. #32 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand_pic_cid/conf.php
    34. #33 /www/wwwroot/www.pjwan.com/lecms/plugin/le_sharejs/conf.php
    35. #34 /www/wwwroot/www.pjwan.com/lecms/plugin/le_slide/conf.php
    36. #35 /www/wwwroot/www.pjwan.com/lecms/plugin/le_special_pro/conf.php
    37. #36 /www/wwwroot/www.pjwan.com/lecms/plugin/le_spider/conf.php
    38. #37 /www/wwwroot/www.pjwan.com/lecms/plugin/le_super_sitemap/conf.php
    39. #38 /www/wwwroot/www.pjwan.com/lecms/plugin/le_title_pic/conf.php
    40. #39 /www/wwwroot/www.pjwan.com/lecms/plugin/le_use_del_id/conf.php
    41. #40 /www/wwwroot/www.pjwan.com/lecms/plugin/le_webp_oss/conf.php
    42. #41 /www/wwwroot/www.pjwan.com/lecms/plugin/le_website_group/conf.php
    43. #42 /www/wwwroot/www.pjwan.com/lecms/plugin/le_zhanqunsitemaps_pro_v303/conf.php
    44. #43 /www/wwwroot/www.pjwan.com/lecms/plugin/lu_huochetou/conf.php
    45. #44 /www/wwwroot/www.pjwan.com/lecms/plugin/models_filed/conf.php
    46. #45 /www/wwwroot/www.pjwan.com/lecms/plugin/qrcode/conf.php
    47. #46 /www/wwwroot/www.pjwan.com/lecms/plugin/sy_mobile/conf.php
    48. #47 /www/wwwroot/www.pjwan.com/runcache/misc.func.php
    49. #48 /www/wwwroot/www.pjwan.com/runcache/core_lang/zh-cn.php
    50. #49 /www/wwwroot/www.pjwan.com/runcache/lang/zh-cn.php
    51. #50 /www/wwwroot/www.pjwan.com/runcache/lecms_control/parseurl_control.class.php
    52. #51 /www/wwwroot/www.pjwan.com/runcache/lecms_model/runtime_model.class.php
    53. #52 /www/wwwroot/www.pjwan.com/runcache/lecms_control/show_control.class.php
    54. #53 /www/wwwroot/www.pjwan.com/runcache/lecms_control/base_control.class.php
    55. #54 /www/wwwroot/www.pjwan.com/runcache/lecms_model/urls_model.class.php
    56. #55 /www/wwwroot/www.pjwan.com/runcache/lecms_model/category_model.class.php
    57. #56 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_model.class.php
    58. #57 /www/wwwroot/www.pjwan.com/runcache/lecms_view/ww7,w10_show.htm.php
    59. #58 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_data_model.class.php
    60. #59 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_model.class.php
    61. #60 /www/wwwroot/www.pjwan.com/runcache/lecms_model/user_model.class.php
    62. #61 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_views_model.class.php
    63. #62 /www/wwwroot/www.pjwan.com/runcache/lecms_model/kv_model.class.php
    64. #63 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_data_model.class.php
    65. #64 /www/wwwroot/www.pjwan.com/lecms/xiunophp/tpl/sys_trace.php