First off, thank you to everyone in this community for all of your help!!!
I am in the planning stage of moving from one MS SQL Server to a replacement MS SQL Server.
I am transferring ALL of the user databases from the old SQL Server and moving them to the new SQL Server that will have the same computer name, instance name, IP address, and logical drive layout. I am using backup/restore.
This is how I plan to move the logins: http://support.microsoft.com/kb/918992/
I am going to be transferring login's and passwords, but am unsure of when I should import the logins. I was hoping to restore one user database and check that that database was working correctly before moving over every user database. To make this happen, I planned to move the logins over before any user databases were loaded.
My concern is that while importing the logins and passwords it won't apply the security to the user databases, because they don't exist yet on that server.
Hopefully I am making sense here and you can help me. :-)