I thought it was simpler in SQL Server 2000 than it turns out to be to move a database from one server to another and restore permissions. At least Microsoft provides a stored procedure to map existing SQL Server logins to users in the database being moved.