• Here are some pointers you can use:

    MovingDB's between Servers : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

    Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers

    Q298897 Mapping Logins & SIDs after a Restore

    Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump

    Q240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers

    Q224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach

    All the above are KB articles and can be searched using the Q<number> from support.microsoft.com.

    HTH,

    Vinod Kumar

    http://www.ExtremeExperts.com