user in database are not login after restoring the database [closed]

开发者_如何转开发 It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago.

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...

---

Maybe this helps: How to move databases between computers. Especially Step 2: How to transfer logins and passwords.

---

Assuming logins exist, you have the "orphaned users" situation

Either use sp_change_users_login or ALTER USER ... WITH LOGIN .. for SQL Server 2005 +