Hi

We've just done this exact process, ie move all our DB's from 1 2005 box to another and I found a login script that worked very well. Not only does it create all the logins but it keeps the passwords too and it also sets the db access correctly.

I won't paste it on this forum as not sure what the protocols are? Are we allowed to do that?

The other replies are what we did too ie.

Stop the SQL service on old server

Detach DB's

Move the mdf and ldf files to new server

Attach DB's

Run login script

Create the jobs running in SQL Agent on the new server

Create new backup and maintenance plans and schedule them. Don't leave this for a week like we did before someone thought about it....

Go to the pub (this one is optional)