"User or Role already exists...."

[BeckahC]

I am trying to copy my whole database, logins and all, using a DTS Package (SQL Server 7.0). I have done this before and it's worked perfectly. This time, I have completed the transfer and went to "update" the logins so that they re register - not sure if that's what it's called, but I go into each login and re-enter the default database and their password and then their login becomes active on the new server. (We are using SQL security)

Anyway, this time I went in to update my own login (went in as SA) and it gave me the message "User or Role already exists in the current database" I was updating the existing login at the time, not trying to make a new one. I tried deleting my login and then adding it again and it told me the same thing....

Then I thought... maybe because I am an admin on the server? So I tried with a different login, for a user with no admin rights, and I got the same error.

Plus, when I look in the Users for the database - there are none except "dbo".

I am running Enterprise Edition of SQL Server 7.0 on the destination box and Standard Edition of the same on the source box. The only other difference I can think of is that The destination box has SP3 and the source has SP2.

Can these differences be the reason? Has anyone else encountered this problem? Does anyone have the solution?

Please help! I am way too far behind on this project to start again from scratch!!!

Thank you in advance for any and all suggestions! BeckahC

 

[RickCole]

Take a look at the following link:

http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q274188

This should help/point you in the right direction.

Rick.

 

[BeckahC]

Thanks, this seems to be doing the trick.... I'll have to test some more to be sure, but I think this is it!

Thank you! BeckahC