mjburgard
asked on
SQL server database migration
I am migrating an SQL database from one server to another. I backed up the database from the server that is operational and restored that backup to the new server. All of the logins apparently were restored, but none of them work. Under security for the SQL server, there are no logins listed - under users for the sql database, all of the logins are listed. I cannot add a login to the security/logins because the users already exist in the database. Is there a way to solve this issue without deleting and recreating all of the users?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, is still works.
ASKER
Thanks - worked well
ASKER
I am going between 2008 and 2008 - The code given in the MS article is for 2005 - these will still work for 2008?