window logins orpahned?

is microsoft script usefu lfor windows login transfers too when i move database from one machine to another, as the window SID's on the new machine would be different, and i have huge number of windows logins in my database.

Is your sql server member of domain or workgroup?

is member of domain

window SID is the same , as your accounts are in the domain.
You need only to add these accounts into the new server.
You can generate scripts from old SQL server for these windows logins , and run it in the new SQL server.

thanks hassan
and i also want to know what if the servers are in the workgroup

when server is in workgroup we use sql authentication (not windows ), because there is not centralized security accounts .

thanks alot hassan

Here is a trick method for Connecting to SQL Server from a workgroup using Windows Authentication
check: http://blogs.msdn.com/sql_protocols/default.aspx?p=2
Take into account effort and in consistency , in case changing password.