SUMMARY
After you move databases to a new server, users may not be able to log in to the new server. Instead, they receive the following error message:
Msg 18456, Level 16, State 1
Login failed for user ‘%ls’.
You must transfer the logins and passwords to the new server. This article describes how you transfer logins and passwords to a new server.