Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-21 : 10:18:42
|
| David writes "Our department is transferring from one domain into another domain. The developers all use NT authentication for database access. How can I rename the existing NT accounts to the new domain that they are in. The user name stays the same, it is just the domain that is changing. I need to do this to maintain all of the different permissions that each individual has on each server for all databases." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 12:36:31
|
| You can not do this without modifying the system tables. I would strongly recommend against this. I would write a script to find the accounts, put them into a temp table, drop the accounts, then add the accounts back from the table but modifying the domain name using SUBSTRING and PATINDEX.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-21 : 23:18:22
|
| Use the sprocs in this link to script them out.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=34196&SearchTerms=sp_hexYou can then drop the permissions, do a find/replace like Tara said and be good to go. This will retain the SID if you need to have the same SID across multiple servers.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-04-23 : 10:06:12
|
| Just update the sysxlogins table. backup master first. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 12:22:00
|
| I would strongly recommend not updating sysxlogins directly. SQL Server ships with an extensive amount of system stored procedures that allow you to modify the system data indirectly.Tara |
|
|
|
|
|
|
Renaming NT authenticated accounts