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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-28 : 14:59:32
|
| Sajan writes "I do have two ms sql 7.0 on two different domains. While trying to transfer database from one to another using DTC, it starts and then fails saying with this error:[Microsoft][ODBC SQL Server Driver][SQL Server]The login 'john' does not exist.additional info:-john is the user inside the database in the source domain-there is no local user account named john in the destination machine but there is 'john' as a user in the destination domain.Does anybody know the easiest way to fix this problem?Basically, what I all want is the easiest way to transfer the database. Any suggestions??" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-07-28 : 23:23:11
|
The easiest way to do this is to uncheck the 'transfer users' or 'transfer logins' checkbox in the task wizard, and manually move the users. I've seen that error message too many times myself  .Jonathan Boott, MCDBA |
 |
|
|
|
|
|
Error on Transfer SQL Server objects