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 |
|
vpathisseril
Starting Member
6 Posts |
 Posted - 2005-06-07 : 14:36:15
|
| My SQL Server is using Windows Authntication and have around 30 Db's on this server. Recently the network team decide to change few NT Ids, is there any way to sync to my new Id rather than me changing manually.If drop the old one and add new one I will lose the the prior security set on database. Any suggestions wouuld be great.Example.Domain/JDoe ==>Domain/JDoe02 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-07 : 15:35:49
|
| Have a look at this in BOL:sp_change_users_loginThat could get confusing if the login names don't match the db usernames. You may want to consider creating security groups (roles) for permissions and then maintain the role members.Be One with the OptimizerTG |
 |
|
|
|
|
|
NT Login Id changes Sync to SQL Server Security