Server: Message 18456, level 16, status 1 user 'sa 'logon Failure Solution

Unable to connect to the server **: SERVER: Message 18456, level 16, status 1 [Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa' Login Failed

Today, I went to the business school room to install the German-Italian e-commerce software. When I encountered the above problem, I felt that the SA user was disabled or the password was incorrect. I asked the Administrator what the SQL password is, I don't know. I am so sweaty -_-!!, Fortunately, I was able to access the Internet. Under Baidu and Google, I found a lot of unclosed posts and there was no solution yet. Finally, I finally found a "Forgot MSSQL Server password SOLUTION ",

-- 1. Clear 'sa 'password exec sp_password null, null, 'sa' -- 2. Change 'sa 'password to 'newpassword' exec sp_password null, 'newpassword', 'sa'

Use the first method to clear the SA password. OK, the problem is solved. It's so hot that I have a change of five cents on my body and a bus ride. Buy popsicles for those five hairs, and sweat ~~~~