Login failed for user 'sa'.(Microsoft SQL Server,Error:18456)
Solution:
1、Login with Windows Authentication
2、Connected, The user is not 'sa'
3、右击sa,打开属性页
4、General——Password——Confirm password
5、Status——Grant——Login Enabled——OK , Save and Exit
6、Open Service Properties Page
7、Security——SQL Server and Windows Authentication mode——OK, Save and Exit
8、Restart Service——Disconnect
9、Reconnect with sa
10、Now, the user is sa