Win7旗舰版
Win7纯净版
Win10系统
Win11系统
系统教程
电脑软件
电脑游戏
手机游戏
手机软件

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

编辑： 毒盅
360集合包
360集合包
360集合包，一键装机、快捷方便。
立即下载   精品合集

在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.怀疑是密码规则不对，



 

相关推荐
最新软件
HermesAgent本地部署工具

HermesAgent本地部署工...

 MathEdit公式编辑器

MathEdit公式编辑器

 SeekFast 本地文档内容搜索工具软件

SeekFast 本地文档内容...

 SeekFast Mac(文本搜索工具)

SeekFast Mac(文本搜索...

 VibeKnow

VibeKnow

 讯飞绘文

讯飞绘文

 码上飞 ai

码上飞 ai

 Atoms ai

Atoms ai
最新教程
1.9128
关
大
基本信息
SQL
$_GET
$_POST
$_COOKIE
包含文件
自动加载
  1. 模型: /www/wwwroot/www.pjwan.com/lecms/model/
  2. 视图: /www/wwwroot/www.pjwan.com/view/m/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 03:59:26
  7. 当前网协: 216.73.216.186
  8. 请求路径: /win10jc/17155.html
  9. 运行时间: 1.9128
  10. 内存开销: 1.09 MB
  1. #0 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cfg' LIMIT 1
  2. #1 [time:0.0001s] SELECT * FROM le_runtime WHERE k='website_group_m_pjwan_com' LIMIT 1
  3. #2 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  4. #3 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  5. #4 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  6. #5 [time:0.0003s] SELECT * FROM le_runtime WHERE k='cate_127' LIMIT 1
  7. #6 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  8. #7 [time:0.0005s] SELECT * FROM le_cms_article WHERE id=17155 LIMIT 1
  9. #8 [time:0.0003s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  10. #9 [time:0.0003s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  11. #10 [time:0.0005s] SELECT * FROM le_user WHERE uid=2 LIMIT 1
  12. #11 [time:0.0172s] SELECT * FROM le_cms_article_data WHERE id=17155 LIMIT 1
  13. #12 [time:0.0003s] SELECT * FROM le_cms_article_views WHERE id=17155 LIMIT 1
  14. #13 [time:0.0003s] UPDATE LOW_PRIORITY le_cms_article_views SET views=views+1 WHERE id=17155 LIMIT 1
  15. #14 [time:0.0002s] SELECT * FROM le_kv WHERE k='navigate' LIMIT 1
  16. #15 [time:0.0002s] SELECT * FROM le_kv WHERE k='le_sharejs' LIMIT 1
  17. #16 [time:0.0004s] SELECT tagid,id FROM le_cms_article_tag_data WHERE tagid=973 ORDER BY id DESC LIMIT 0,6
  18. #17 [time:0.0003s] 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
  19. #18 [time:0.0004s] SELECT * FROM le_cms_article WHERE id=103441 OR id=103329 OR id=103274 OR id=103160 OR id=103106
  20. #19 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_1' LIMIT 1
  21. #20 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  22. #21 [time:0.0005s] SELECT id FROM le_cms_pcsoft WHERE (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) ORDER BY id DESC LIMIT 0,8
  23. #22 [time:0.0005s] SELECT * FROM le_cms_pcsoft WHERE id=681 OR id=680 OR id=679 OR id=678 OR id=677 OR id=676 OR id=675 OR id=674
  24. #23 [time:0.0003s] SELECT * FROM le_user WHERE uid=1 LIMIT 1
  25. #24 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_68' LIMIT 1
  26. #25 [time:0.0002s] SELECT id FROM le_website_group WHERE webdomain='m.pjwan.com' AND is_active=1 ORDER BY id ASC LIMIT 0,1
  27. #26 [time:0.0002s] SELECT id FROM le_cms_article WHERE cid=68 ORDER BY id DESC LIMIT 0,5
  28. #27 [time:0.0003s] SELECT * FROM le_cms_article WHERE id=79666 OR id=79665 OR id=79664 OR id=79663 OR id=79662
  1. #control => show
  2. #action => index
  3. #cid => 127
  4. #id => 17155
  5. #mid => 2
    1. #cdn_sec_tc => 0819529f17870831581047712e0e2d3736db05b9597de6d959245a59b4
    2. #acw_tc => 0819529f17870831581047712e0e2d3736db05b9597de6d959245a59b4
    3. #PHPSESSID => mqptgobqa5ngsn06n0li45b6pd
    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_model/website_group_model.class.php
    54. #53 /www/wwwroot/www.pjwan.com/runcache/lecms_control/show_control.class.php
    55. #54 /www/wwwroot/www.pjwan.com/runcache/lecms_control/base_control.class.php
    56. #55 /www/wwwroot/www.pjwan.com/runcache/lecms_model/urls_model.class.php
    57. #56 /www/wwwroot/www.pjwan.com/runcache/lecms_model/category_model.class.php
    58. #57 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_model.class.php
    59. #58 /www/wwwroot/www.pjwan.com/runcache/lecms_view/m,w10_show.htm.php
    60. #59 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_data_model.class.php
    61. #60 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_model.class.php
    62. #61 /www/wwwroot/www.pjwan.com/runcache/lecms_model/user_model.class.php
    63. #62 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_views_model.class.php
    64. #63 /www/wwwroot/www.pjwan.com/runcache/lecms_model/kv_model.class.php
    65. #64 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_data_model.class.php
    66. #65 /www/wwwroot/www.pjwan.com/lecms/xiunophp/ext/utf8.class.php
    67. #66 /www/wwwroot/www.pjwan.com/lecms/xiunophp/tpl/sys_trace.php
    1. #0 utf8 类