When i restored database from one server to other server the user's are not login in database but its shown in database then i delete it and make it again through sql/server/security/login and then its work. is someone tell me how can i restore database and do not define user every time...
+4
A:
Maybe this helps: How to move databases between computers. Especially Step 2: How to transfer logins and passwords.
Konamiman
2009-11-12 07:43:52
Might also be step 3, orphaned users
gbn
2009-11-12 07:57:33
+1
A:
Assuming logins exist, you have the "orphaned users" situation
Either use sp_change_users_login or ALTER USER ... WITH LOGIN .. for SQL Server 2005 +
gbn
2009-11-12 07:56:25