Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jsimmons
Starting Member
14 Posts |
 Posted - 2004-11-01 : 18:18:53
|
| We have recently moved databases from one server to another (both SQL Server 2000). I continue to receive the following error(s):From Enterprise Manager under the Security area, when selecting a specific user and attempting to select the databases to access, I receive the following error:"Error 21002[SQL-DMO] User 'XXXX' already exits."Also, when attempting (via Query Analyzer) to log in with a specific user, I receive the following error:"Msg 18456, Level 16, State 1; Login failed for user 'XXXXX'." I would guess I am receiving this error since I am unable to grant specific database access (i.e. the prior error).I have verified that all the roles and permissions are concurrent with the source database.Can anyone assist?Thanks! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-01 : 21:58:59
|
i recently posted same issue last week.solution: rebuild the accounts and reapply the permissions, roles are not affected only the logins (which is pretty weird).  --------------------keeping it simple... |
 |
|
|
|
|
|
Login Errors