User login problem on copied database 1

[ajones]

I copied the data and log files from a database on our production server to a test box and attached them to my test database. Only the default logins appeared in the Security-->Logins folder. I added a SQL Server Standard login that my testers always use with this application. That went fine.

I tried to add a standard login required by the production application which runs against this database. Enterprise Manager told me the login already existed. When I pressed <OK>, the login appeared. I went into properties to add permissions to the production database. When I hit <OK> again, I got the same login already exists message.

Can anyone tell me what I did wrong in trying to set up this test version of my database? And can you tell me how to fix it?

Thanks!

 

[RickCole]

To quote from a previous Terry L. Broadbent post:

&quot;It is common to have mismatches between logins and users when moving databases from one server to another. You can easily fix that problem with sp_change_users_login.

Check this article for more info.

Fixing broken logins and transferring passwords

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp&quot;

Rick.

 

[ajones]

Thank you both. I did every keyword search I could think of with no success before I tossed out this question. This is exactly what I was looking for.