Users did not migrate

Last Post 18 Jun 2004 10:05 AM by bigelectricmac. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bigelectricmac
New Member
New Member

--
18 Jun 2004 07:38 AM
Hi,

I am converting SQL Server 7.0 to 2000 running on separate boxes. I use detach/attach method. Also I created a DTS package which moves all logins from source server ( 7.0 ).

After I attached my database to destination server ( 2000 ) , I checked users, there are no users except dbo in destination database.

And even I have tried to perform migration in 2 different orders: first is to import logins and than database files, and other way around: first database files and than logins . Result is the same: no users in my database.

Am I doing anything wrong ?

Thanks
bigelectricmac
New Member
New Member

--
18 Jun 2004 10:05 AM
Thanks a lot for quick response.
It works fine.


Acceptable Use Policy
---