[sql server] Microsoft SQL Server Error 18456, Login failed for user as 'SA'

Microsoft SQL Server Error 18456, Login failed for user

新安装的sql server 2017, 并安装了 ssms, 添加了user 并给与足够的权限, 之后使用其以sql authentication的方式链接sql发现还是登录不上.

links

解决方案: https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/

检查是否开启了 sql Authentication Mode

检查user是否enable

检查这个user的role mapping和permission

这个就不截图了.