To successfully copy a login from one server to another, you'll need to ensure that the copy has the same SID and password. The link between database users and logins is done with the logins SID -- if ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...