user does not exist

[Guest_imported]

Hi
Iam getting the following error message when transferring data from one database to another database in sql server.

the error message i got is

"There is no such user or group"

Can anyone help me in rectifying the problem.

Later i found this error in SQL SERVER booksonline as error no 4604 but no solution is given

Regards
Vinod Kumar

 

[tlbroadbent]

THe error occurs when trying to grant permissions to a user name the doesn't exist in the destination database. Determine the user(s) who have permissions on the objects you are transferring and create those users in the destination database.

Which version of SQL Server are you running and how are you transferring the table? Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[Guest_imported]

Hi Terry L. Broadbent,

Thank you for your response.

Iam sure user exists on the destination database.the use exists and has the following privileges

1.db_owner
2.db_datareader
3.db_datawriter
4.db_accesadmin
5.db_securityadmin
6.db_ddladmin
7.db_backupoperator

iam using SQL SERVER 7.0 version and iam using DTS to transfer data.

Regards
Vinod Kumar

 

[tlbroadbent]

If all the users with permissions on the source objects exist in the destination database, then I don't understand the error.

Is it possible that you have created aliases in your databases? We've eliminated the use of aliases so I don't know if that could cause the error you see.

FYI: You don't need to assign all the roles you have assigned to the user. If a user is db_owner then that user has all the permissions of the other roles you listed. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.