How to transfer logins and passwords between instances of SQL Server

Migrating, disaster recovery even database mirroring will need this.
Check the Microsoft KB article, bookmark for future reference.

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.


About noneil
Rapper turned Rockstar!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: