Database copy between servers - user logins corrupted
Posted
by Steve
on Stack Overflow
See other posts from Stack Overflow
or by Steve
Published on 2010-03-16T21:43:55Z
Indexed on
2010/06/14
22:32 UTC
Read the original article
Hit count: 132
sql-server-2008
|windows-7
When I copy a database from one server to another via backup and restore, I find I have to recreate the users in the database. I can't login as them right after the copy - I get cannot open default database, when the database that was just copied is the default database. Why is this? The logins exist on the target copy server.
© Stack Overflow or respective owner