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 ?