|
Home > Archive > MS SQL Server > July 2005 > DB move from one domain to another
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.
| |
| Narayana Vyas Kondreddi 2005-07-15, 9:23 am |
| 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.
|
|
|
|
|