copy database wizard errorCode=-1073548784

I am transfering a database from sql server 2000 to sql server 2005 using copy database wizard.

I have this error coming up error

Error: ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @.loginame = N'Test\username', @.name_in_db = N'username' " failed with the following error: "The login already has an account under a different user name.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()

How do i handle this error...looked online but didn't find right answers...

Please let me know

Hi sureshv,

It seems that it migrates database users. This is not the same as logins.
Logins have access on server level, users on database level.

Perhaps - it may works by using sp_changedbowner 'sa'

CU

tosc

|||

WHEN I AM USING A COPY DATABASE WIZARD HOW AND WHERE DO I NEED TO USE sp_changedbowner 'sa'

AND OTHER QUESTION IS DOES THIS COPY WIZARD EVER WORK PROPERLY...

so i though to use a backup and restore method in order to tansfer 2000 database to 2005 server.....Which worked out well but i have this error coming up when i tried to run my backup for the databse transfered in 2005....

"Executed as user: Companyname\dba. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."

How to overcome this situation..sqlsql