Error 18456 occurs when SQL Server adds a user

1. Login with native default window authentication

2, after the successful login, in the database-"security-" login-"right-click Properties-" select "New login name"

3. In the login name, enter the user who will create the new login, and enter the corresponding password

4. Change the status to set to grant, enabled

5. Then click OK to see the following user creation success

7. In the database that you are currently affiliated with, right-click

8. Then change the server authentication mode on the security on the SQL Servers and Windows authentication modes

9, need to shut down or restart the SQL Server service, the convenience of direct restart

10. Login

11, login success, as shown, user hello

Error 18456 occurs when SQL Server adds a user