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 |
|
bigred
Starting Member
1 Post |
 Posted - 2006-04-27 : 19:29:03
|
| I'm migrating from an NT4 domain to a 2k3 domain but the SQL server stays the same.After the migration I need to change the user login from 'domain\user' to 'newdomain\user' and I continue to generate an error using sp_change_users_login (Terminating this procedure. The User name 'domain\user' is absent or invalid.)I can change the name of the account using sp_prefix_sysusersname, yet this does not help me change the login account. I have numerous accounts in numerous DB's to change due to the new domain name while keeping existing permissions for those users. All users are public and DB owners.How can I change the login name? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-27 : 21:09:55
|
| generate a script for logins including the drop statement and permissions plus group membership, change the old domain name to the new one on the script, run the scripti haven't found an easy way out for this, somebody here may though--------------------keeping it simple... |
 |
|
|
|
|
|
Changing User Login