DB move from one domain to another

I have a SQL 2000 DB that needs to move from one domain to another (no
trusts). How do I map new users to the DB from the new domain? Basically,
I know the users between two domains, and they have same type of permission,
I just need to make sure their Windows login in new domain will enable them
to access the DB in the new domain
Thank you.
You will have to grant access for those new Windows accounts to SQL Server.
See sp_grantlogin in SQL Server Books Online. Then grant them database
access using sp_grantdbaccess. Then apply permissions at the database level.
If you have a role in your database, that has all the required permissions
assigned, then it will be simle - you just have to add those database users
to the role.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KP" <kp@.msn.com> wrote in message
news:eVVNlOUiFHA.572@.TK2MSFTNGP15.phx.gbl...
I have a SQL 2000 DB that needs to move from one domain to another (no
trusts). How do I map new users to the DB from the new domain? Basically,
I know the users between two domains, and they have same type of permission,
I just need to make sure their Windows login in new domain will enable them
to access the DB in the new domain
Thank you.